Search results

Okay, I must be an idiot. I can't get the offset forumula to work. Apologies. So in Tab "Model", i have the folowing data Cell AY66, AY67, AY68, AY69 data $1.50 $1.75 $2.00 $2.25 In Tab "Summary", I'd like this data to simply re-display as: Cell Data B5...

I tried the fromula =OFFSET(Sheet1!$A$1,0,ROW()-1) It did not work when I filled the forumula down a column. All of the filled cells referred to the same cell without sliding right. How do I get the reference to slide right, while filling down? Thanks, and sorry for my simple problems.

I wish to simply refer a cell in one tab to a cell in another tab within the same workbook. So Tab1 cell A1 = "Tab2 cell A1" Then, in Tab1, fill DOWN the formula but moving the reference ACROSS not down. So that in Tab1, when I fill down three cells, the resulting formulas would be: A2 =...