Macro needed to merge Excel worksheets in a particular format
£25-50 GBP
Paid on delivery
I have a spreadsheet with dozens of tabbed worksheets, with exactly the same headings and number of columns. I know how to merge these together into one worksheet, but I need to have them merged with a new column added which contains the name of each worksheet.
I've attached a spreadsheet as an example.
Project ID: #7130652
About the project
25 freelancers are bidding on average £33 for this job
Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi: Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90% of my completed projects are related to Excel and macro. Please connect with me to disc More
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More
Hello, I can get this task done in the next 1 to 2 hours. Let me know if you are interested. Thanks
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me More
That would be quite simple . Just add the sheet name in the first column in each worksheet. Perhaps you can do it yourself. If however you want a macro to do it, I can create one for you
Hello, I have seen your project and attached sheet. I can do this work with 100% accuracy and within time. I have already created a formula which provides tab name as result. I 'll apply that formula and then proceed More
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: V More
Dear sir, I will use VBA to complete your project. For each sheet, I will copy data, and the latest column will set as name of this worksheet. Waiting for your reply, thanhhungqb
Hello there, I would like to be considered for this job as I have great working experience in VBA macro writing and have completed few projects on freelancer with 5 STAR ratings. Thanks, Ramesh
dear sir I have 5 year experience in excel vba.. please do consider my bid... please see my portfolio in freelancer
Dear Ms/Mrs/Mr You need someone to do an excel work for you. Merged the content into a new column which contains the name of each worksheet. So here's my bidding. Your excel attached cannot be opened (corrupt). And More