I need certain data from 110 Excel Workbooks combining into 1 csv file
- or -
Post a project like this1988
£20/hr(approx. $25/hr)
- Posted:
- Proposals: 9
- Remote
- #2188707
- PRE-FUNDED
- Awarded
Ranked in Top 10 % of Web Developers on PPH - Woocommerce, Wordpress,PSD to HTML,CSS
Ahmedabad
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
1449473143588190114103050616424921889454211818722235642417757
Description
Experience Level: Expert
Estimated project duration: 1 day or less
Each workbook has 3 spreadsheets, Import, Forecast & Export. As per attached Sample. For each workbook I need all the data rolling up into 4 columns, The first is the customer number (there is one workbook for each customer and the customer number is in cell O2 in the Import sheet). The second column needs to container the SKU's which are in the Forecast sheet, column A. The 3rd column is the quantity, the quantities are in the forecast and reflect the period which can be seen along the 1st row, the first period being column D 201901 (yyyy/mm). Fourth column is the period which relates to the quantity.
What's needed is a formula or macro to role all these number up together from all the different spread sheets. I can send a sample separately but don't want to post confidential sales information.
What's needed is a formula or macro to role all these number up together from all the different spread sheets. I can send a sample separately but don't want to post confidential sales information.
Gerard H.
100% (4)Projects Completed
3
Freelancers worked with
3
Projects awarded
50%
Last project
15 Mar 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies