LinkBack URL
About LinkBacks
I would like to create a macro that would pull all the data from multiple worksheets (1-4) and put it onto a mastersheet ("SummaryPage"). However, I only require rows which have a "1" in the "Priority" column (D).
Can this be done?
Thank you!
I would like to create a macro that would pull all the data from multiple worksheets (1-4) and put it onto a mastersheet ("SummaryPage"). However, I only require rows which have a "1" in the "Priority" column (D).
Can this be done?
Thank you!
Try the below code.....
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi, :) Sixthsense :),
didnīt try the code but shouldnīt it be
for a new row instead of overwriting the last row withPlease Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
The below line is resetting the value of x, so the data won't get replaced, I believe
Please correct me if I am wrongPlease Login or Register to view this content.
Thanks for the input
Hi, :) Sixthsense :)
This will get the last visible row of data, for copying either Offset or the number of lines to do so should be inserted. Thatīs what a test with the command shows in the Immediate window.so the data won't get replaced, I believe
Ciao,
Holger
Yeah you are right exactly
That code was written in the beginning stage and offered long back ago and I am keeping folders for similar threads and I am just doing copy paste of my older code's with minor change to suit the OP's data. So I missed to see that part.
Thanks for correcting it
Originally Posted by :) Sixthsense :)
Thank you! This is exactly what is needed. However, using "Set rMyRng = wNew.Range("B" & x) + 1" in place of "Set rMyRng = wNew.Range("B" & x)" only pulls the rows with a "1" in the "Priority" column (D) from sheet "2" only.
Could the rows that have a "1" in the "Priority" column (D) from all sheets (1-4) be pulled?
Thank you!
Hi, mjwmgmt,
the code must read (sorry for spreading confusion on that with a wrong code)
Ciao,Please Login or Register to view this content.
Holger
Hi HaHoBe,
Now I don't see anything on the "SummaryPage". Here is what I have currently:
Please Login or Register to view this content.
Hi, mjwmgmt,
maybe give this altered code a try:
Ciao,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks