| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cells to the left of an event in a cell
I need some help writing code. When I type "d" in any cell on the
spreadsheet, I want excel to initiate a macro that will automatically copy the values of the two cells to the left of it. For example: if I type "d" and then enter in cell C3, I want it to automatically copy the range A1:A2. OR if I type "d" and then enter in cell F7, I want it to automaticall copy the range G7:E7. Any combo like that should work. The last step I can do, which is pasting special values in the next available cell of a different sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cell to the left | Excel Discussion (Misc queries) | |||
| macro to look down cells and if negative in the right of the cell change to left of the cell | Excel Programming | |||
| Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Programming | |||
| Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
| Copy formula relative to left cell? | Excel Programming | |||
Threaded Mode
