Link to home
Start Free TrialLog in
Avatar of Nirvana
NirvanaFlag for India

asked on

merge all workbooks to one workbook

I have 50 templates of the same format, which has multiple tabs in it, all the 50 templates have to be consolidated by summing each cell from all the templates and give a summary file.

for example: I will receive PnL templates from 30 different regions which needs to be consolidated by adding all the cells (except for the cells where i have formulas) and create a summary tab

i am attaching a sample it have to consolidate all yellow cells. the path for each file will be different, a message box will be popped up which will ask for the path of the files

thanks a lot in advance
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Uday,

The file is missing...

Saurabh...
Avatar of Nirvana

ASKER

sorry here is the attachment
sample-profit-loss.xls
SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Nirvana

ASKER

Hi Ejgil Hedegaard.. the solution is great however just need some tweaks.. sorry for providing a sample file of 2003 this have to done in versions of 2007 i have updted dir to xlsx.. and

also can you provide a solution to update all sheets. the sheets names will be always same

the regional finance managers will update this file. how can i make sure this is not updated twice and build a control..

thanks a lot again for your time. really really appreciate it
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Nirvana

ASKER

super solution. thank you very much. yes there are some changes that have to be done..like building a control, where an user migh click same file twice so it might double entry.