Relative formulas and cells

[bugmcw]

My favorite sounding board,

I have a sheet of formulas that pull data to create essentially a marketing report. Unfortunately, the way the sheet is set up now, whenever I have new data added, i have to move each cell down 1 (or over 1 as the case may be). My question is can i move cells relative to one another? For instance:

cell A1: =B1
cell A2: =B2

If i change cell A1 to =B2, i want cell A2 to automatically go 1 cell below whatever A1 equals.

in order words: if a1=b1 then a2=b2 and if a1=b7 then a2=b8

I hope this makes sense, thanks everyone!

 

[njimack]

Maybe something like this? Use a helper column, referenced with INDIRECT

Excel Workbook
	A	B	C	D	E	F
1	0					1
2	0					2
3	0					3
4	0					4
5						5
Sheet1

 

[bugmcw]

THanks for your help, but I'm a little lost. What would go in the place of "B"?
What does the formula =+F1+1 represent? I haven't seen a =+ before?

Thanks again!

 

[njimack]

You misunderstand. You want A1 to link to B1, hence the "B" in the INDIRECT formula. The "+" in column F is redundant - I only used formulae in column F to increment the row by 1. The below might explain a bit better.

Excel Workbook
	A	B	C	D	E	F
1	Text1	Text1				1
2	Text2	Text2				2
3	Text3	Text3				3
4	Text4	Text4				4
Sheet1