user input decides cell copy range
 

Ciao,
can anybody please help me.
I want to copy using a macro.
I want to copy a range of cells specified from user input (sa
specified in cells a1 & b1) information in some other cells on th
sheet. I want the specified range of cells to copy to a template shee
in exactly the same position.
Then I want the macro to go back to the previous sheet and then afte
reading another cell in the user input information (say c1) whic
specifies which sheet to go to next. The macro will then use the ne
A1&b1 on that next sheet to know which cells to copy.

Can I just use some formulas for this or does a macro do this better


Grazie


Beatric

--
beatrice2
-----------------------------------------------------------------------
beatrice25's Profile: http://www.excelforum.com/member.php...fo&userid=3450
View this thread: http://www.excelforum.com/showthread.php?threadid=54302