Using a Macro to copy & Paste from one sheet to another.
Solved/Closed
Marksman702
Posts
3
Registration date
Monday December 15, 2014
Status
Member
Last seen
December 17, 2014
-
Dec 15, 2014 at 09:08 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Dec 18, 2014 at 05:19 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Dec 18, 2014 at 05:19 PM
Related:
- Using a Macro to copy & Paste from one sheet to another.
- How to transfer data from one sheet to another in excel using formula - Guide
- Google sheet right to left - Guide
- Little alchemy cheat sheet - Guide
- How to screenshot excel sheet - Guide
- Excel macro to create new sheet based on value in cells - Guide
7 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Dec 15, 2014 at 04:50 PM
Dec 15, 2014 at 04:50 PM
Hello Marksman,
Looks like you've busy trying to work this one out!
To simplify and better understand exactly what you would like, please upload a sample work book. Please desensitise any confidential information.
Use a file sharing site such as DropBox to do this.
Regards,
vcoolio.
Looks like you've busy trying to work this one out!
To simplify and better understand exactly what you would like, please upload a sample work book. Please desensitise any confidential information.
Use a file sharing site such as DropBox to do this.
Regards,
vcoolio.
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Dec 16, 2014 at 10:10 PM
Dec 16, 2014 at 10:10 PM
Hello Mark,
Just letting you know that I haven't forgotten you. I'll be tackling your case again tonight when I get home from work. I went through it last night with a fine-tooth comb (well, fairly fine anyway!).
Just wondering, did you record the current macro with the macro recorder?
Regards,
vcoolio.
Just letting you know that I haven't forgotten you. I'll be tackling your case again tonight when I get home from work. I went through it last night with a fine-tooth comb (well, fairly fine anyway!).
Just wondering, did you record the current macro with the macro recorder?
Regards,
vcoolio.
Marksman702
Posts
3
Registration date
Monday December 15, 2014
Status
Member
Last seen
December 17, 2014
1
Dec 17, 2014 at 04:44 AM
Dec 17, 2014 at 04:44 AM
Hi Coolio,
Yes mate I used the Macro recorder, it is a little messy, I will tidy it up a little : )
Yes mate I used the Macro recorder, it is a little messy, I will tidy it up a little : )
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Dec 17, 2014 at 05:15 AM
Dec 17, 2014 at 05:15 AM
Hello Mark,
That's ok. Leave it as it is. Sorting through it for you. Will be in touch.
Cheers,
vcoolio.
That's ok. Leave it as it is. Sorting through it for you. Will be in touch.
Cheers,
vcoolio.
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Dec 17, 2014 at 11:47 PM
Dec 17, 2014 at 11:47 PM
Hello again Mark,
Click on the following link to retrieve your file:-
https://www.dropbox.com/s/gpezz3vvxwvji8u/Marksman.xlsm?dl=0
I've re-arranged your code so now it transfers data as you wanted - row by row - to the SDR List.
I have made your existing button "Create List" the active cell also so, when you click on it, all the data will be transferred. Its in cell R2. If you ever move the button, you will need to change the cell reference in the code.
Also (and I hope that you don't mind), I had to re-arrange your form ("Single SDR") a little as there were many, many merged cells that created havoc with the code. There are no merged cells now. To trim the code down, I have removed the formatting code from the macro but both sheets are still formatted, and saved, as you had them originally. You can change and save the formatting any time you wish.
I have placed the code in Module 1 as it was not being used.
I hope its now all working as you wanted.
Kind regards,
vcoolio.
Click on the following link to retrieve your file:-
https://www.dropbox.com/s/gpezz3vvxwvji8u/Marksman.xlsm?dl=0
I've re-arranged your code so now it transfers data as you wanted - row by row - to the SDR List.
I have made your existing button "Create List" the active cell also so, when you click on it, all the data will be transferred. Its in cell R2. If you ever move the button, you will need to change the cell reference in the code.
Also (and I hope that you don't mind), I had to re-arrange your form ("Single SDR") a little as there were many, many merged cells that created havoc with the code. There are no merged cells now. To trim the code down, I have removed the formatting code from the macro but both sheets are still formatted, and saved, as you had them originally. You can change and save the formatting any time you wish.
I have placed the code in Module 1 as it was not being used.
I hope its now all working as you wanted.
Kind regards,
vcoolio.
Didn't find the answer you are looking for?
Ask a question
Hi Coolio,
Thank you very much, I have tidied it up now similar to the original, you were right
that merged cells were causing a problem and found that if you un-merged the titles
the macro would work.
Please see the link
https://www.dropbox.com/s/bs1oo8oom7dsgvt/Trim%20SDR-List%20Creator.xlsm?dl=0
Once again thanks very much, I have also learned a lot from your good work and can use it on other tasks.
Kindest Regards
Mark
Thank you very much, I have tidied it up now similar to the original, you were right
that merged cells were causing a problem and found that if you un-merged the titles
the macro would work.
Please see the link
https://www.dropbox.com/s/bs1oo8oom7dsgvt/Trim%20SDR-List%20Creator.xlsm?dl=0
Once again thanks very much, I have also learned a lot from your good work and can use it on other tasks.
Kindest Regards
Mark
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Dec 18, 2014 at 05:19 PM
Dec 18, 2014 at 05:19 PM
Hello Mark,
Great tidy up work on the form! I knew you'd make that your first task. It looks great now. I was more interested in unmerging everything.
I'm actually still playing around with the code to try and make it more efficient. I'll let you know if it turns out any better.
Glad that I could help.
Cheers,
vcoolio.
Great tidy up work on the form! I knew you'd make that your first task. It looks great now. I was more interested in unmerging everything.
I'm actually still playing around with the code to try and make it more efficient. I'll let you know if it turns out any better.
Glad that I could help.
Cheers,
vcoolio.
Marksman702
Posts
3
Registration date
Monday December 15, 2014
Status
Member
Last seen
December 17, 2014
1
Dec 16, 2014 at 06:50 AM
Dec 16, 2014 at 06:50 AM
Hi Coolio,
Thanks for the quick reply buddy, please see the link to the file below
https://www.dropbox.com/s/zkn5n4v1g9wu7kr/Copy%20of%20SDR%20list%20test.xlsm?dl=0
Basically the first tab (SDR) is filled in, I click the Create file list and the second worksheet tab 2 is completed. then what I want to be able to do is everytime I create a new SDR and create the list it moves down to row 2 and so on.
I hope the link works ok, or do I need to do it a different way?
Many thanks
Mark
Thanks for the quick reply buddy, please see the link to the file below
https://www.dropbox.com/s/zkn5n4v1g9wu7kr/Copy%20of%20SDR%20list%20test.xlsm?dl=0
Basically the first tab (SDR) is filled in, I click the Create file list and the second worksheet tab 2 is completed. then what I want to be able to do is everytime I create a new SDR and create the list it moves down to row 2 and so on.
I hope the link works ok, or do I need to do it a different way?
Many thanks
Mark
