My apologies if this has been answered already in another post, but I've been searching through the posts for over 2 hrs and am unable to locate anything that works.
I need a code that will copy any cells with data in range I3:I41 from sheet2 and paste it in sheet1 starting at cell B3. Then copy any cells with data in range I3:I41 from sheet3 and paste it in sheet1 starting at the next empty cell.
Thank you
Hello MissaLissa,
It was not clear to me if you were using the "friendly" tab names for the worksheets. This macro uses the worksheet code names rather than "friendly" tab names, which means you can change the "friendly" name without changing the macro code.
Please Login or Register to view this content.
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!)
Thanks for quick response Leith. I guess I should have been a little more specific...
I have the "Master Sheet" and then I have a sheet for each day of the week (Monday, Tuesday, etc). I need to copy data from worksheet called Monday and paste in cell B3 on the master sheet, then copy data from Tuesday and paste in the next empty cell of the Master sheet. And so on and so forth. Each week day spreadsheet will have a different amount of cells to copy. See Attached.
Thank you for your help
Last edited by MissaLissa; 04-25-2014 at 03:35 PM. Reason: Attachement
Hello MissaLissa,
Nothing attached to your last post. It happens from time to time. Try it again.
It's there now... It took me a minute to remember how to get the attachement option... forgot to go advanced.
Hello MissaLissa,
Thanks for the workbook. That makes everything clear. I will correct the macro based on this workbook's layout.
Hello MissaLissa,
The macro has been added to the workbook and a button added to the "Main" sheet to run the macro.
Please Login or Register to view this content.
Oh man, it's so close I can smell and taste it.
It's pasting a blank cell if there is no data in any of the weekday worksheets. Is there a way to eliminate that? (See Attached)
Hello
Here is the updated macro. It has been added to the attached workbook.
Please Login or Register to view this content.
Good morning Leith - Hope you had a wonderful weekend and thank you for helping me out on this.
The code works great. I just have a couple of questions...
1. How do I use this code to have Thursday & Friday copy and paste to another list? (See Attached)
2. If I wanted to copy more than one column wouldn't I just simply add it to the range?
Please Login or Register to view this content.
Last edited by MissaLissa; 04-28-2014 at 09:17 AM. Reason: added attachement
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks