Link to home
Start Free TrialLog in
Avatar of ssblue
ssblueFlag for United States of America

asked on

Combine all sheets into one

Excel - I received assistance on some code that updates a master sheet based on several other sheets.  
I would like to be able to use different workbooks instead of different tabs.
Example: Have 4 or 5 work books that update a Master file. The master file would contain the Change log
CombineIntoOne.xlsm
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Are all the files in one folder?
Avatar of ssblue

ASKER

yes
Is the e\ample attached based on a master workbook. That is, will the other workbooks be the same layout  - sheets for various people and a change log. Each sheet will then be imported to the master workbook and added to the relevant sheet there.
Avatar of ssblue

ASKER

Yes, all sheets will be laid out the same and reside in the same folder with the Master showing the latest revision.
I'll have a look at adapting some code for you.
Avatar of ssblue

ASKER

Thanks!!
I haven't tested this so it might need some tweaking. Check it out on sme dummy workbooks and let me know. I'll be around tomorrow if you need changes
CombineIntoOne.xlsm
Avatar of Professor J
Professor J

Hi ssblue

you can use http://www.rondebruin.nl/win/addins/rdbmerge.htm    Free Excel add-in RDBMerge

User generated image
Avatar of ssblue

ASKER

Professor J, thanks for the info however I can't use an Excel add-in at work. :(

Roy, I'm not sure I explained this correctly.  The example I posted works fine. Each tab is updated to the Master tab.  However what I would like to do Is have Five (or more) separate files. One for each person and One Master file. All files would reside in the same location. Each person would open their file to work on and the Master file would automatically be updated.
The file you posted seems to me similar to the original one I posted, If I am missing something here please let me know. Sorry for the confusion.
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland 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 ssblue

ASKER

That's what I was afraid of. What we have now is working but I was hoping for something that might eliminate some confusion for the users. Sometime they click on the wrong tab. : (
Thanks for the help and advice. I think I will close this question if no one objects.
Avatar of ssblue

ASKER

Both offered insight and helpful suggestions but nothing that would work in my setting.
How do they click on the wrong tab? Surely they have one tab in their own workbook.

Also, the problem I see is how do you only import/export new items, are existing items deleted after saving?
Avatar of ssblue

ASKER

So there is one workbook with 5 tabs, Master tab and tabs with their names. They will click on someone else's tab for whatever reason - I don't know .
Each sheet is exactly alike with all the information needed except for the columns where updates are to be made. So each person is responsible for their own rows based some of the information in the sheet. No new rows should be added once the updates begin. If there is a need for some new rows to be added then they are added to all the sheets.
I have a userform that requires the user to enter their name and password to access their worksheet. Take a look, if it helps I can add it to your workbook
PASSWORD-FORM-7.xlsm