i dont want vlookup to solve this

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 that’s contains data
for sheet1 has its own date ) it will effect auto on sheet1
I think am bad in explaining these thing but I don’t want to use VLOOKUP I
want a formula is there any ??
 
Back
Top