Excel: copy data to specific cell based on user input

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

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of November 16, 2014.

For more resources for Microsoft Excel