| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
inserting rows affecting formulas on other wkshts
We are importing data into a worksheet from a .csv file. Data from this
worksheet is then being used in formulas with results on other worksheets within the workbook. When data is imported again (updated) on the first worksheet and new rows of data are included, the results of the formulas are then messed up on the other worksheets because they are referencing the wrong cells because new rows of data have been inserted. Any way to remedy this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying & Inserting Rows w/o Affecting other Rows Etc. | Excel Worksheet Functions | |||
| Copy Formulas when inserting rows | Excel Discussion (Misc queries) | |||
| How to copy several wkshts into one worksht with formulas? | Excel Worksheet Functions | |||
| Inserting formulas etc after n rows | Excel Discussion (Misc queries) | |||
| Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
Threaded Mode
