Excel file has two sales reports on one sheet. I have 24 files to modify. Anywhere from 600 to 3000 records for each file. I need help writing a macro to sum the dynamic range of sales for Sales Report 1 and Sales Report 2, even though the total field/cell will always be in a different spot on each report. I've written some of the macro. ***
Hi zebracaro, I not...noticed your profile and would like to offer you my project. We can discuss any details over chat. I just need to move some rows around, and perform some logic steps all through VBA if you feel that is the most efficient. Ultimately it will form a trading program that will perform what you create on many rows(>150) independently.
...[url removed, login to view] I will send as a seperate link the items to add This is a fixed priced job, You can bid above the range bid, I will consider all offers whether high or low. when you bid please PROVIDE ONE SAMPLE OF WORD WORK YOU HAVE DONE with checklist of VBA in the PAST ideal candidate
We need a freelancer to develop CMP (Construction Management Project) using Ms Access platform that include Forms, Reports, SQL and Vba to develop the application with the following specifications: - *) Database include main 4 tables as Contractors, Projects, Works and Archive. *) Freelancer should hold a Bachelor or Master degree in one of computer
I have some work, in an Excel spreadsheet.
I need a google apps script that will trigger when a certain cel...reminder with the string of text that was entered into the trigger cell. This script will be used to notify team members when a task has been delegated to them via a google sheet spreadsheet by adding a popup reminder to their calendar that alerts them that a new task has been added
I need you to fill in a spreadsheet with data. To design VBA for invoices data input to excel worksheet, from the excel than create DO, Sales Order and save all in pdf file and print out Also save all invoices data in to xls for account use.
...done been able to do this for the reports described in the first paragraph but I have no idea how to write the VBA required to Loop through to generate the annual reports for every donor AND include this logic as well. Additionally, if the VBA could set the email to send via gmail instead of Outlook, that would be -amazing- but not 100% required.
do some data analyst work and spreed sheet work immediately
...Create an Excel user interface for the user to enter criteria data to generate a report(s) using the data in the spreadsheet. Results will be view-able using a user-friendly, easily understood display layout. Display will have an option to print the report. The report will have a user friendly, easy to read layout. Ability to convert results data
I have a Google sheet I will be using to present info to my clients. It's a financial planning checklist. As we complete tasks over the years or hit milestones, the client sees that they are progressing financially. It will be used in annual reviews with our clients. They will also have the document shares with them so they can update at home. I
...are 21 hostels on this website. [url removed, login to view] I need someone to help me build a VBA scrapping tool on Excel to extract data from these 21 hotels on [url removed, login to view] So there will be 21 sheets of Hotel on the excel file. Each sheet will have 365 days of prices for 1) twin rooms, 2) triple room, 4) quadruple rooms. If rooms are sold
...footprint for 30 different countries which I randomly selected. All of the data for each country's biocapacity and ecological footprint from the years 1990-2013 is located on the excel workbook titled "EF and Biocapacity per country". I need help with transferring that information to the workbook titled "GDP PPP data" so that I may analyze it. I have already
I am working with another freelancer developing a database of monitoring well sample results. I have approximately 50 locations (wells) and we routine samp...intended only to explain how I think we might proceed. I expect the successful freelancer will work with the freelancer I have already hired to develop these statistical tests in VBA programming