LinkBack URL
About LinkBacks
I have a workbook that has 17 tabs; each with a unique name. I am wanting to get a formula or way to transfer all of that data onto one master list tab. The columns are all going to be the same I just need the data to go on its own row.
I have a workbook that has 17 tabs; each with a unique name. I am wanting to get a formula or way to transfer all of that data onto one master list tab. The columns are all going to be the same I just need the data to go on its own row.
.
Paste into a Routine Module :
Please Login or Register to view this content.
Thanks for your quick response! This was perfect! i really like the refresh button you added on the master tab!
Last edited by Scott.Applewhite; 07-25-2017 at 08:13 PM.
Is there any way to not have the header row from all of the tabs return on the master page multiple time? Not a huge issue, this will work for what I need but just curious.
Thanks again for your help!
I don't understand why it would be copying row 1 from each sheet to the master ... it does not do that here.
It only copies Row 2 and down to the last used row.
Well everything was going well until i went to load it into Google Docs only to realize that Google Drive does not support VBA.......uggggg Do you know a easy way to convert this string so it will work while in Google Drive?
.
I am not familiar with Google's form of Excel. I only know that most of it is compatible with Excel but there are a few quirks.
Sorry.
Does anyone now a better way to get this document to populate a master list of names and info from other tabs? I am going to load in to either One Drive or Google docs so that over a dozen people can add names to the document and then i would like it to automatically update the Master list of names and info.
.
I got to looking at the macro and experimenting. Previously all the sheets had some kind of test data. When I cleared one sheet of all data except the Column Headers, I saw what you are seeing on your end.
The macro, for that single sheet, was copying the headers and pasting them to the Master List sheet.
Having changed the macro around, see if this works better for you :
Please Login or Register to view this content.
Hey Scott,
How about another idea here. What if each person had their own workbook with a single sheet, where they add data. Then you put all their workbooks into a single directory/folder and append all of them to a single workbook. This is a new feature in Excel 365 called Get & Transform. No VBA needed.
http://excelunplugged.com/2015/02/10...n-power-query/
https://support.office.com/en-us/art...8-6a00041c90e4
The beauty of this is you can have more and more people add files to the folder and simply run the PQ again and it will gather up all those files into a single master.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks