| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you copy formulas only across a large sheet, under data?
If you have a sheet with a perfect formula that covers 4 rows/13 columns
Each 4 rows repeats 200 times (over 800 lines) Can you copy just the formulas in the first section, to the other 199 4/row sections without changeing the dates and the cell headings? I tried copy, paste special formulas, BUT it changed all the data below to match the first 4 rows. In Fact I tried paste special (all choices).. Didn't work. Thanks Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste Macro using large amount of Data | Excel Discussion (Misc queries) | |||
| Automatically copy data from large worksheet into individual workb | Excel Worksheet Functions | |||
| copy part of large WS to another sheet | Excel Worksheet Functions | |||
| How do you copy a sheet (with Formulas) to another Workbook? | Excel Discussion (Misc queries) | |||
| Help with large amounts of data and formulas | Excel Worksheet Functions | |||
Threaded Mode
