Hi
I want to consolidate 3 worksheets into a single summary sheet, I've found the following code but it stops at the highlighted bit saying that it isn't defined. I got the code from Microsoft's website so I'm a bit puzzled
Can anybody help me please? I got the code from
Please Login or Register to view this content.
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
You have not copied the Lastrow function from that site.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
facepalm-500x4001.jpg
Thanks
Last edited by davidman1; 11-06-2012 at 08:00 AM.
OK....So now I've defined the function I can either have the header row listed twice or I can have the data with no header row.....is there a way of getting one header row and all the data?
The macro has the startrow as 2, which is the row below the header in your case, right?
Yeah, but if I change the start row to 1 then it copies the headers in from every spreadsheet (they're the same in each one).
Yeah, why do you want to change it to 1? Leave it as it is.
I need the headers in there too.
One way you can do it is this - After "startrow = 2", enter this line
This works fine as long as there are not too many headers, you will be spending time in typing in each one. When you specify the range A1:J1, ensure that you put in 10 headers in the split brackets. I just put in 5 for now.Please Login or Register to view this content.
Thanks - that's great!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks