Create Macro's within Excel to pull out data from one Excel sheet and populate anothe
- or -
Post a project like this- Posted:
- Proposals: 12
- Remote
- #1304852
- Awarded
Description
Kind of development: New program from scratch
Description of requirements/functionality: 1. Excel Sheet 1 contains live jobs which are different each day. We need to create Macro's within Excel to daily pull out certain data from Excel sheet 1 and populate excel sheet 2 with certain predetermined columns.
2. Excel sheet 3 contains all prices for every job type. We need to pull out price data from this sheet which matches the job type undertaken for that day into sheet 2.
Extra notes:
Ajeet M.
100% (14)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Ajeet,
If this job is still open for bidding, please could you send me a more detailed breakdown of what you are after (with any example files you may have). This should allow me to prepare an accurate quote for you.
Thanks,
Mark -
Hi Ajeet
I'm assuming that sheets 1 and 3 are data sheets and sheet 2 is a result sheet which can be regenerated daily to either pull out data for that day or mabe a running total or maybe both.
Beyond that the scale of what you require is too vague to make even a reasonable guess at costs and timescales.
Would you want this automated or generated by triggering a button. Would you need any input parameter data that might vary the data extracted? It all sound do able but I need a little more specific information to estimate a cost that would meet the required functionality and at a quality that would make you want to use the product.
Best Regards
Dave -
Hi,
Please can you send me a brief example of
1. The details of the job that are entered in spreadsheet 1 and the columns that need to be entered into spreadsheet 2.
2.Also please supply example data of the price info that needs to be entered into spreadsheet 2.
This will help so I can supply an accurate quote for the job.
Many Thanks
Darshy -
Hello Ajeet
Do you have an example of the spreadsheet we can take a look at please?
Thanks and regards
Stuatr
-
Hi, please can you share the Excel workbook with input/output as you need it to be.
Thanks,
Ashley