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.