hello
i have the following macro in "my workbook"
what i would like...if in the range B10:P1009, the data is last reported on row 696, can the macro only consolidate the data in the master sheet of the active cells i.e. B10:P696?
Please Login or Register to view this content.
my data is consolidated into the "master" worksheet, starting in cell B10....
can someone pls help!
any thoughts guys?!? thxs
any thoughts or updates guys? thx u
Are you consolidating data from multiple worksheets or multiple workbooks?
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]
hello
yes i am.
the worksheets i am consolidating my data from are P1, P2, P3...P12
also, in my master sheet where the data is being consolidated, column A is a # cell i.e. A10 = 1, A11 = 2, A12 = 3 etc
ur thoughts? thx u
hello all
any thoughts?? thxs
You can try this codeWhat is the name of your Sheet17? You have specified that as a condition. I have not included it, since i didnt know what the sheetname was. What if the sheet no changes to 18? In that case, its better to specify the name in the condition, like if .name <>"Test".Please Login or Register to view this content.
hello quick question and thx u so much for your help!!
if for instance in my worksheet "P1"...where the data is being extracted from into the master sheet, contains one blank row...will the macro automatically adjust to pick up the next row or will it jump into the next sheet "P2" and extract data from there? thx u so much for your kind help.
The macro will check for the last row with data in column B in each worksheet beginning with P. It does this by going to the last row in excel and climbing up to the last row with data. If there are blanks in between, it will include that as well. Then, it will move to the next worksheet.
hey arlu
thxs for your wonderful help. i am using the macro in the "workbook" sheet as when the users go are on the P1, P2..P12 sheet, i would like the macro to automatically consolidate the data from the P1-P12 worksheets.
the only issue using the macro you provided...it is taking a long time and also, it does not overwrite the existing data in the master sheet
here is the code
Please Login or Register to view this content.
Why are you using the workbook_sheetdeactivate event? You can use it as normal sub-routine as in Sub copy_data(). This could be slowing down your code.
To clear the contents of the master sheet, use this updated codePlease Login or Register to view this content.
hey arlu
the sole reason why i was using workbook_event was to make the macro automated.
ideally i do not want the user to run any macros. i would like if.when they click on another worksheet, the data gets consolidated into the "master" sheet. does that make sense...will the updated macro you provided perform that task?
thx u so much for your help, it is really appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks