VBA code for copy & paste items for multiple times
Solved/Closed
andrewhu91
Posts
3
Registration date
Thursday June 28, 2018
Status
Member
Last seen
July 3, 2018
-
Updated on Jul 9, 2018 at 06:35 AM
andrewhu91 Posts 3 Registration date Thursday June 28, 2018 Status Member Last seen July 3, 2018 - Jul 3, 2018 at 12:11 PM
andrewhu91 Posts 3 Registration date Thursday June 28, 2018 Status Member Last seen July 3, 2018 - Jul 3, 2018 at 12:11 PM
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 28, 2018 at 11:01 AM
Jun 28, 2018 at 11:01 AM
Hi Andrew,
Why not copy C2:F479. Then on the other sheet hit:
- Ctrl+v
- End
- Arrow down
- Arrow down
repeat 8 more times.
Then select column C:F and sort on column F.
Best regards,
Trowa
Why not copy C2:F479. Then on the other sheet hit:
- Ctrl+v
- End
- Arrow down
- Arrow down
repeat 8 more times.
Then select column C:F and sort on column F.
Best regards,
Trowa
Updated on Jun 28, 2018 at 11:14 PM
Jul 3, 2018 at 12:06 PM
Thanks for the feedback. I haven't had the time for the VBA code as I prioritise new query's.
Do take a look at the link below as it does pretty much the same thing; repeating a number of rows:
https://ccm.net/forum/affich-1052135-copying-time-fields-down#p1052306
Let me know if you are still waiting for a code tailored for your situation.
Best regards,
Trowa
Jul 3, 2018 at 12:11 PM