I had a problem solved for me previously here. However, I now have additional data that needs to be copied over to a new sheet. This data includes blank cells.
I embedded an If statement to help fix the issue, but it doesn't seem to work.
Can anyone tell me what I'm doing wrong? I've attached my sample.
Please Login or Register to view this content.
Last edited by Ricker090; 04-27-2011 at 01:50 PM. Reason: Solved
Hello Ricker090,
It would help to know what the expected outcome looks like.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Sorry about that.
I've attached the expected outcome.
Hello Ricker090,
Thanks for doing that. I didn't mean for you do that much work. Just a few sheets would have been fine.
It wasn't a problem. I actually let the macro create the sheets, I just manually copied and pasted the additional data.
Hello Ricker090,
Sorry for the delay. I have rewrote the macro to be more flexible and faster. A button has been added to "Sheet1" to run the macro. Here is the revised macro code...
Please Login or Register to view this content.
Holy Crap! It's awesome. Thanks!
I had a quick follow up question. If I wanted to paste my header and subsiquent data starting in row 7, how would I modify the code? I attempted to modify the If statement that pasted the header with the following code, but I takes the next line of data and pastes it into row 1.
Please Login or Register to view this content.
Hello Ricker090,
Change the NextRow number from 1 to 7...
Please Login or Register to view this content.
I tried that and it and doesn't copy the header over. Any other suggestions?
Hello Ricker090,
I changed the macro to start at "A7" on the individual destination sheets. The macro has been tested and works. Replace your old macro with this code.
Please Login or Register to view this content.
That did it! I'm greatful for everything that you've done. Thank you so much.
Re: Copy and paste data to separate sheets based on mutiple criteria again
Holy crap...this is amazing!! I modified the VBA code for my purpose and it works great. THANK YOU!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks