Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 (say specified in cells a1 & b1) information in some other cells on the sheet. I want the specified range of cells to copy to a template sheet in exactly the same position. Then I want the macro to go back to the previous sheet and then after reading another cell in the user input information (say c1) which specifies which sheet to go to next. The macro will then use the new 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 Beatrice -- beatrice25 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543020 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Reference with Range Name | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Input Cell in One variable data table | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions |