Hi all
I struggling to have a macro that allow me to copy data to specific cell based on user input.
Example:
I have "X" data in A2
I need a macro prompt to enable user to input how many "X" to copy & paste to cell
I am looking at the user will first have the cursor at A2 & then click a button (with macro) which prompt how many X to copy & paste.
The offset to paste is fixed, ie. in column C, E & G
Then if the User want to repeat for A3, the process is repeat as above.
A1 B1 C1 D1 E1 F1 G1 H1
A2 X X X X
A3 X X
Anyone can help me
Cheers
I struggling to have a macro that allow me to copy data to specific cell based on user input.
Example:
I have "X" data in A2
I need a macro prompt to enable user to input how many "X" to copy & paste to cell
I am looking at the user will first have the cursor at A2 & then click a button (with macro) which prompt how many X to copy & paste.
The offset to paste is fixed, ie. in column C, E & G
Then if the User want to repeat for A3, the process is repeat as above.
A1 B1 C1 D1 E1 F1 G1 H1
A2 X X X X
A3 X X
Anyone can help me
Cheers