| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy to destination of "A50" + value in I12 (sequence#) A51,A52
I amy trying to copy the current value of a row from one worksheet (Data
validated list) to another worksheet. The first time the destination is "A50", the second time has to be "A51" so as not to overwrite previous copy. In cell I12 is the selected sequence number to assist (1,2,3,4,5...)but I cant figure out how to use the value in I12 to advance the destination from A50 plus that value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? | Excel Programming | |||
| Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? | Excel Programming | |||
| Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? | Excel Programming | |||
| How to set a default paste option of "Match Destination Format" | Excel Discussion (Misc queries) | |||
Threaded Mode
