So I'm trying to pull the data from a specific sheet in a list of work books into one master sheet. The data is in the sheet "Data", and per workbook there is one row and 12 columns. the current formula I have is(I've included the error next to it related line):
Sub getDataFromWbs()
Please Login or Register to view this content.
Last edited by Stokess; 10-30-2018 at 07:27 PM.
Hi,
Can you try this instead :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Thanks, but now I'm having the issue of it pulling data from all the sheets within the workbook. Is it possible to make it pull from only one sheet(all with the name data) within each workbook?
Yes it's possible. But can you clarify which data you want to pull from those workbook and copy to the master workbook?
Is it only the last row?
all rows?
12 columns?
Thanks,
(Having a sample workbook would help...)
Like this?
Please Login or Register to view this content.
Sent you a private message with the data sets
above i have included another spot where i am now getting error codeOriginally Posted by GC Excel
Different method
Please Login or Register to view this content.
Hi,
Here's a revised code.
it is not clear which columns you want to copy to your master workbook.
As an example, I put columns 11-12-13-14. Change as required.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks