ssblue
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
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
Are all the files in one folder?
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.
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.
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
CombineIntoOne.xlsm
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Thanks for the help and advice. I think I will close this question if no one objects.
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?
Also, the problem I see is how do you only import/export new items, are existing items deleted after saving?
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.
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
PASSWORD-FORM-7.xlsm