Macro needed to merge Excel worksheets in a particular format

Completed Posted Feb 12, 2015 Paid on delivery
Completed 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.

Excel

Project ID: #7130652

About the project

25 proposals Remote project Active Feb 12, 2015

Awarded to:

Pichart

Dear Employer, let me introduce myself a little, I am an excel developer, expert in Excel both excel standard and Vba coding, more than 10 years. You can see more of my profile and expertise in this forum http://www More

£40 GBP in 1 day
(38 Reviews)
5.3

25 freelancers are bidding on average £33 for this job

jaylancer43

A proposal has not yet been provided

£49 GBP in 3 days
(561 Reviews)
8.2
P0L

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.

£35 GBP in 1 day
(255 Reviews)
7.0
aarifakhtar

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

£25 GBP in 0 days
(152 Reviews)
6.9
avinav606lx

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

£42 GBP in 0 days
(146 Reviews)
6.3
gokulanand

Hello, I can get this task done in the next 1 to 2 hours. Let me know if you are interested. Thanks

£25 GBP in 0 days
(96 Reviews)
6.0
nagybatonyi

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

£38 GBP in 2 days
(62 Reviews)
5.7
rumapaul

A proposal has not yet been provided

£50 GBP in 3 days
(46 Reviews)
5.4
teeares

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

£25 GBP in 3 days
(50 Reviews)
4.9
touqeerqamar

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

£25 GBP in 1 day
(23 Reviews)
4.4
boriscikotic

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

£40 GBP in 3 days
(7 Reviews)
4.0
thanhhungqb

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

£25 GBP in 0 days
(14 Reviews)
3.5
rameshmahala

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

£44 GBP in 3 days
(4 Reviews)
2.8
SWAPANCHOWHAN

dear sir I have 5 year experience in excel vba.. please do consider my bid... please see my portfolio in freelancer

£26 GBP in 3 days
(4 Reviews)
1.9
shebrien

A proposal has not yet been provided

£25 GBP in 1 day
(2 Reviews)
1.6
technoarts

A proposal has not yet been provided

£25 GBP in 3 days
(0 Reviews)
0.0
abdulazim86

A proposal has not yet been provided

£41 GBP in 3 days
(0 Reviews)
0.0
salmanmajeed

A proposal has not yet been provided

£25 GBP in 3 days
(0 Reviews)
0.0
milan2210

I do all works sincerely.

£29 GBP in 8 days
(0 Reviews)
0.0
SoftAr

Hi, I have the knownledge to provide the solution you are requesting. I have an extensive experience in Excel macros and Visual Basic so I could give you the solution in the same day you adjudge me the project. Ho More

£26 GBP in 0 days
(0 Reviews)
0.0
keumalahayati

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

£41 GBP in 2 days
(0 Reviews)
0.0