Jan 03 2018
09:49 PM
- last edited on
Jul 25 2018
09:47 AM
by
TechCommunityAP
Jan 03 2018
09:49 PM
- last edited on
Jul 25 2018
09:47 AM
by
TechCommunityAP
Dear all,
I'm looking for a solution to copy and paste some cells from a sheet to another using VBA as there are many cells to copy this cannot be done manually and need some help. Attaching the excel file where i need help to get that done.
Regards,
Aditya
Jan 03 2018 11:57 PM
SolutionJan 04 2018 01:23 AM
Dear @Wyn Hopkins,
Thank you for the solution but still i would like to know the process of automating it using VBA. Pivot table has helped me save my time hugely but to be frank i need to learn VBA too. So please help me with it.
Regards,
Aditya
Jan 04 2018 04:09 PM
Jan 18 2018 09:58 PM
Jan 03 2018 11:57 PM
Solution
I would use a Pivot Table as first option
see attached file