...data on a daily/weekly basis. Based on the few conditions , it has to be put into specific cells in the main database with minor manipulation. Looking for an expert excel/VBA freelancer to assist . Sheets DQ-45, DQ-46, DQ-47 & DQ-48 are identical. However they represent 4 different people who move to various locations . On each location various activities
I need and expert in Visual Basic for Applications to create Macros in order to automate tasks in Excel by writing so-called macros. This is for a project repeated every 3 months. Attached are the spreadsheets we have put together. I also attach the end result which gets fed through the excel information. We take the financial statements for ten banks
we have a database in Microsoft Access and we want relied this a management planning for our drivers. please discuss in private for more details not need you share with me your other skills, I want only VBA developer and if you share other skills I not reply
I need a VBA script that will use the spreadsheet and create outlook emails that will send to each individual recipient listed. Example email body: Hello, I see that PO# (value from spreadsheet) was not picked up yesterday. Can you please advise if this freight is ready for pickup today?
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 t...data: [login to view URL] I have highly detailed instructions written out for this project that I can provide upon further discussion. Project ID: 17959315
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from ...containY. Example input data: [login to view URL] I have highly detailed instructions written out for this project that I can provide upon further discussion.
...from an Excel which uses a VBA uder-defined function. I have no plans to make this commerical yet, I just want to see what is possible and at what price. The minimum viable app will be called "Mr Simple" and will need to work on Android and iOS entirely offline and the app must be capable of being modified by any Microsoft Visual Studio installation
Need someone expert in Excel. I have an excel file and i want to translate it in English. Also it downloads data from web, and i need to have it online, so i need to transform it into a googlesheet file.
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 ...containY. Example input data: [login to view URL] I have highly detailed instructions written out for this project that I can provide upon further discussion.
Hi, I have a VBA code written in excel file (macro). It performs the calculations. I will provide you the code and I need someone to provide detailed description for each line of the code. (eg. how code works, what each line does, what each line means etc.)
I just need a form where I can enter details and that should be added to my access database, it's very simple. You should only use VBA code in MS Access, no other language or inbuilt feature of MS Access. I will give you all the table related information
Need VBA to sum numbers. First, the VBA looks into column B to identify product category. After it looks into column D. In column E it creates the sums with a MAX value of 800. As you can see on the picture we have many sums within the same product category.
Hi there! I have been working on an excel vba macro that transfers data from one workbook to another. The part that I am stuck on is how to transfer several rows of data from one workbook to another and at the same time setting things up so the next time data is transferred, it will go under the previously transferred data. The majority of the macro
...similar so that rescaling doesn't skew it somehow. We will do the logic in Excel, we are lookiing for someone to build the Autocad interface. We would write the logic in Excel VBA to control the Autocad variables, but we need help with the interface (eg, defining which dimensions change, which stay constant when you alter a variable). The program would
Please don't bid without looking at attached worksheet. If you do, I won't eve...Worksheet. The winning person will: *Have advanced knowledge of Excel. *Be able to start immediately *Be available for hourly work over the next 10 days to assist me complete the project. *Normally works during these hours. I am available now to chat or explain my needs.
Using the keywords "Website Spokesperson" my competitor takes up 4 positions on the first page of google search. Two of them are on one domain and the other two are similar pages under two different domain names. Same company, slightly different content. [login to view URL] [login to view URL] [login to view URL] [login to view URL] My websites are [login to view URL] , [login to vie...
Desired output is an Excel (Mac Version 14.7.7) spreadsheet which prioritizes restock from vendors by sales volume and/or profitability. Inputs are two data files exported from Quickbooks ("sales" and "stock") which are attached. Note that these data export files can be modified to some degree if required. Also, "sales" data file includes data for all inventory year-t...
I need a faster VBA macro. It's important to mention that the data I intend to scrape needs expanding to view the data required. It's like vertical tabbed content if you will. XML http is faster you can use it or other way but goal is fast vba. Apply if you can deliver this and pls do so within my budget.
I need a XXXXXXXXX expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
...provided content (photos, simple script for texts, etc...). These are photo-based intro videos for a conference. We have examples, but they are too large to be attached to this project. They will be sent to the candidate. No filming will be required. We need at least 2 videos within a week. The client is a large international organisation and they will
I need help with developing a VBA code for the attached example document which essentially only uses two functions: copy-paste and goalseek. If you can develop and implement the code in the attached document using the named ranges, then I can import the code into a confidential document it shall be used in.
...higher in Computer Science or related field • Solid understanding of MS Access, MS SQL Server database technologies and experience with SQL query/SQL programming • Familiar with VBA scripting programming and C#, .NET skills • Experience in system administration or development is preferred • Open to fresh graduates who have a passion in the data-related field
Need Excel VBA macro to Get EndDate+Time from StartDate+time and Duration (hours) Requirement 1. The calculation should account for holidays (see holiday format below) 2. The calculation should account for workdays (see details below)
Hey Folks, I want assistance in completing the functionality of the prototype. Please make sure you go through the document before you make BID.
I would like to create an application that will integrate with Microsoft Outlook 2016. VBA and .net framework are definitely a requirement for this application. Some design experience would also very helpful. It would be ideal if we can determine if this application will also work on Outlook for MAC. I would like to be able to create a full CRM, Document
Need help with setting the group policy of my domain managed on windows 2003 server. Want to set the policy to push a desktop background to all domain users on all client workstation WITHOUT any steps on the workstations. Also want to set the policy to push a homepage setting to all browsers on all domain users on all client workstation WITHOUT any
I have to sort Bill of Material data that I am getting from Inventor and than associate additional material to that data and arrange it in a pre-defined format. Images att...BOM. 4. It should check the parts in the BOM and associate the accessories and put it under the BOM list. see image attached. We can discuss in detail after the start of project.
...with IIF statements. There is a variable in the formula so they are not basic or simplistic. So please read through the attached carefuly before bidding or accepting the project. The formula are DateDiff but the formula depends on whats selected in one of the fields on a form in the database. My Max price $45 US. Please Dont bid more. If you know
...Structure the document to remove some confusion on instructions sheet, moving the SQL extract to different tabs 2. Add drop down menus for each column for who is responsible for that column in the instructions tab 3. Add a workings tab which groups the responsible together based upon instructions tab 4. Add a summary tab of which department needs to