I have 3 sheets in excel
1) 1st sheet has 15 columns and about 60K rows.
2) 2nd sheet has 2-3 columns, 1K rows
3) 3rd sheet as 2-3 columns, 500 rows
There is a common ID across all three sheets
Using the data in the above tables..
I need someone to split the data in the tables into multiple excel workbooks and multiple sheets so that for every "common ID" it will have its own workbook with three sheets. and the data in those three sheets will only include data relevant to the "common ID".
You will need to export the data into a template workbook i have prepared and you will need to follow the order of the columns provided in the template.. (I have formulas and pivot tables running off the template so you will need to ensure that I can continue to use the template in the various workbooks you have created for me)
I also need the output workbooks to have the naming convention for example - "common ID" - "[table1] [field3]".xlsm
Serious bidders only.. you will be expected to turn this around in 1 day
Thanks
Such jobs are my daily practice. I can complete the job in some hours. My bid includes the macro doing the job if you need it for further use. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
Regards!
I can do this for you in one day. I've worked several projects like this recently and have the code ready now. It should only need some minor tweaks to work with your data as described. I have years of experience working with Excel data and I do this type of work every day. Please PM me with any questions or further details you may need from my end before we start working together. Looking forward to helping you.