Forum Discussion
Solved
Automate excel to copy a range from one sheet to another
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
4 Replies
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
- Hi
The VBA code would be quite time consuming and relatively complex to write / teach. My advice with VBA is to try and get yourself on a course if at all possible and learn the core concepts and rules for writing good VBA. It sometimes can be too easy to just use the Macro recorder and then leave your code with bad VBA.
How much VBA have you written in the past. Are you comfortable with declaring variables, loops, named ranges etc?
