burnin2emax
New Member
- Joined
- Nov 9, 2005
- Messages
- 10
Hi there,
I need help in a macro to perform the following.
The situation is as such :
I have a cell C6 waiting for user input.
I want to create a control button which runs a macro which will copy certain range of cells according to the user input.
For example, when a user keys in "a" at cell C6, when the macro is run, columns(A:D) of Worksheet A are copied to columns(B:E) of Worksheet B.
When a user keys in "b" at cell C6, when the macro is run, columns(E:H) of Worksheet A are copied to columns(B:E) of Worksheet B.
Hope someone can help.
Thanks in advance.
I need help in a macro to perform the following.
The situation is as such :
I have a cell C6 waiting for user input.
I want to create a control button which runs a macro which will copy certain range of cells according to the user input.
For example, when a user keys in "a" at cell C6, when the macro is run, columns(A:D) of Worksheet A are copied to columns(B:E) of Worksheet B.
When a user keys in "b" at cell C6, when the macro is run, columns(E:H) of Worksheet A are copied to columns(B:E) of Worksheet B.
Hope someone can help.
Thanks in advance.