| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and insert cells with macro
Hi All,
On Sheet1 is a range F1:R500. In some of the cells in column R is number €œ1€. What I need is to create a macro which will do the next: for every row in range F1:R500 if the cell in column R is 1, copy cells F:R, then go to Sheet2, insert a row, paste copied VALUES from Sheet1 in cell F1 of Sheet2 and copy the formulas from G2:L2 to G1:L1 of the same worksheet. Any Help is highly appreciated. Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Insert Macro | Excel Discussion (Misc queries) | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| Macro to insert copy and insert formulas only to next blank row | Excel Programming | |||
| macro to insert rows & copy cells | Excel Programming | |||
| macro to insert row, copy cells and keep hidden columns | Excel Programming | |||
Threaded Mode
