How I can make a cell contact with another cell on another sheet and it will
changes when day changes.

example I have cell A1 sheet1 contact with cell A2 sheet 2 and cell A1 sheet
2 is the date when the date change A1 sheet 1 will auto change to B2 sheet 2
and the date = B2

Hi,

I don't understand the last bit about B2 but with is in Sheet1 A1 it will
change whenever Sheet2 A1 changes.

=Sheet2!A1


Mike


"Ali.Abughrabieh" wrote:

How I can make a cell contact with another cell on another sheet and it will
changes when day changes.

example I have cell A1 sheet1 contact with cell A2 sheet 2 and cell A1 sheet
2 is the date when the date change A1 sheet 1 will auto change to B2 sheet 2
and the date = B2

its hard to explain lets say I have a report and sheet 1 is the index for
the report sheet 2 is the changeable data in sheet 1 I have a date =now() and
it will auto change by date the cells from sheet1 will take the data from
sheet 2 so when the date changes ( in sheet2 every cell thats contains data
for sheet1 has its own date ) it will effect auto on sheet1
I think am bad in explaining these thing but I dont want to use VLOOKUP I
want a formula is there any ??



"Mike H" wrote:

Hi,

I don't understand the last bit about B2 but with is in Sheet1 A1 it will
change whenever Sheet2 A1 changes.

=Sheet2!A1


Mike


"Ali.Abughrabieh" wrote:

How I can make a cell contact with another cell on another sheet and it will
changes when day changes.

example I have cell A1 sheet1 contact with cell A2 sheet 2 and cell A1 sheet
2 is the date when the date change A1 sheet 1 will auto change to B2 sheet 2
and the date = B2