Changing cell reference

[moonchildja]

Hi, I am having trouble trying to write a formula.
So, in tab A, weekly we add a new column with new data. in tab B, we want to compare last week's data with this week's data. But since we add a new column, for example if last week's data was in cell A5, but for this week, last week's data is going to be B5. So the cell reference contiuously changes. So the data I want is from row 300 where the column=last week's date(today()-7). The row is constantly 300, but the column changes every week, I want it to automatically update. So, I want the interesection of the two condition I guess but not sure how to state row=300 or column=today()-7, there's got to be a way and I would love some help.
Thanks,

[Rahbee]

Can you give an example sheet or an example of some output you would expect?

[Azam Ali]

Hi moonchildja

try the following in you tab B,

=INDIRECT("'Sheet1'!A300")
=INDIRECT("'Sheet1'!B300")

Kindly Note that Sheet1 is the name of tab from where you want to pick the data.

Kindly post a sample workbook if it does not help.