Thanks for your time and help
Thanks for your time and help
Last edited by prkhan56; 09-21-2015 at 01:08 PM.
I think you missed a set of H10 data from either Sheet1 or Sheet3, but otherwise this code mirrors you results on Master.
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Thanks for the prompt reply.
But when I run the code it gives me
Run time error 9 - Subscript out of range error
and highlights
Set M = Sheets("Master")
Can you please check the code.
Do you have a sheet named "Master" in the workbook you're running the code in? If not, change "Master" to match the name of the sheet you're trying to compile the data in.
Edit: just saw that you asked that the macro create the Master sheet. This code does not do that and will require a bit of a re-write to do. Give me a bit.
Last edited by walruseggman; 09-18-2015 at 04:13 PM.
Try the attached.
Your output columns on are not aligned. I am not sure if you want it that way. As there are no data in Column "H" sheet 2, this should create a gap in you want to align the data.
Last edited by AB33; 09-19-2015 at 07:10 PM.
It works leaving gaps in between which I will manage to delete using select blanks - delete - shift cell up
Thanks for your time and help.
I have added alternative code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks