Hi.
I've struggled with this most of the day and I could really use some help. Is there a way to change the code below from pasting the entire row to only pasting the data in columns A:E?
Please Login or Register to view this content.
Hi.
I've struggled with this most of the day and I could really use some help. Is there a way to change the code below from pasting the entire row to only pasting the data in columns A:E?
Please Login or Register to view this content.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thanks, JLGWhiz.
The only issue remaining is that data in column A is not being copied. The code needs to compare the letters in column B to the tab names, but when the copy/paste occurs it needs to include columns A through E data.
Attachment 653552 shows the results of the original vs the modified code. I've also uploaded a copy of the workbook.
Attachment 653552
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Works perfectly. Thanks!
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks