Insert line in Excel

[ranebow]

I have a 2 page workbook. First sheet should ALWAYS pick up cells from line 3 of second worksheet. Problem is....each week I insert a line BEFORE line 3 and enter current week info. When I do this the formula on the first sheet updates to line 4! HELP!

 

[SkipVought]

Hi,

Insert is the scourge of references!

Rather...

add you data in the first available row at the bottom of your list and then SORT if necessary to reorder the list.

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[byundt]

ranebow,
If you post the formulas that are vexing you as data gets added, perhaps we could suggest some alternative formulations that will permit the insertion.

For example, if you are summing a range and row 2 contains titles, your formula could start on row 2. Other methods include using INDEX, OFFSET or INDIRECT functions to refer to row 3.
Brad

 

[ranebow]

Thanks for help, but a gentleman at work helped me. We reveresed the spreadsheet and did a VLOOKUP on the date field to pull from the second sheet.