| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Copy/Paste Special Formulas/Paste Special Values
How would someone copy the last row of data on a sheet, go
down one row, paste only the formulas, then go to the original row and paste the values. The original row would have the same values but no formulas and the next row would then have the formulas. This needs to be dynamic because the rows would increase by one row daily and the reference would change each day. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my paste special function won't let me copy formulas | Excel Worksheet Functions | |||
| Changing Of Values After A Copy And Paste Special: Why ? | Excel Discussion (Misc queries) | |||
| Copy Values only without Paste Special | Excel Discussion (Misc queries) | |||
| Copy / Paste Special / Values for a whole spreadsheet ? | Excel Discussion (Misc queries) | |||
| How to copy formulas to a new workbook? Paste Special is different | Excel Worksheet Functions | |||
Threaded Mode
