| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Broken link between worksheets
HELP! I have one workbook in which Sheet 1 imports data from Quickbooks. It always has the same number of rows and columns. I want Sheet 2 to pull data from Sheet 1 to create another report where G4 on Sheet1 is the same as G4 on Sheet 2.
Initially, I imported the data from Quickbooks, then typed +Sheet1!$G$4 into the Sheet 2 cell. However, when I import new data to replace old data on Sheet 1 (again, same number of rows and columns - the numbers just change within the cells) my Sheet 2 cells all say #REF! error. Any idea how I can fix this? I'm assuming it gets confused when I replace old data with new in Sheet 1. Trixie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
| how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions | |||
| Put same data in cells on two different worksheets (link?) | Setting up and Configuration of Excel | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| What formula do I use to link worksheets together within one spre. | Excel Worksheet Functions | |||
Threaded Mode
