hi everyone,
i wonder if someone please could guide me - i'm new to VBA and come across with a situation and hoping that one of your expert could help me please. Here is the situation :
- In my workbook I have 6 sheets (different sheet names i.e. A,B,C,D) and in each sheet I have data from Row A2 to however long it goes.
What I want a macro button - when user click on it :
1. Input box to browse and define which file to copy to
2. Copy all the data from each sheet to the same rows in the other sheet with the same sheet name.
3. In the other workbook - those sheets are hidden so unhide > copy > hide.
4. Finally message box to confirm copied
I would really appreciate if someone could help me.
Many thanks,
i wonder if someone please could guide me - i'm new to VBA and come across with a situation and hoping that one of your expert could help me please. Here is the situation :
- In my workbook I have 6 sheets (different sheet names i.e. A,B,C,D) and in each sheet I have data from Row A2 to however long it goes.
What I want a macro button - when user click on it :
1. Input box to browse and define which file to copy to
2. Copy all the data from each sheet to the same rows in the other sheet with the same sheet name.
3. In the other workbook - those sheets are hidden so unhide > copy > hide.
4. Finally message box to confirm copied
I would really appreciate if someone could help me.
Many thanks,