I have to create a share spreadsheet with 15 tabs, each of mine 15 workers would work on a individual tab. They would basically enter data. I would like to have 1 more tab at the end which would be a copy of all tabs. Is that possible?
I have to create a share spreadsheet with 15 tabs, each of mine 15 workers would work on a individual tab. They would basically enter data. I would like to have 1 more tab at the end which would be a copy of all tabs. Is that possible?
This could only happen with VBA. If you want help with this, then you should submit a SMALL sample workbook. Showing what your original data would look like and what your desired result should be.
IF the information in each sheet is fixed and will not get wider than it is now you could write code like this.
this is in Sheet16 A-Z
=SHEET1!A1
this is in Sheet16 AA-AZ
=SHEET2!A1
this is in Sheet16 BA-BZ
=SHEET3!A1
You could then copy-drag these throughout the desired range
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks