Transfer data relevent to date

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

Guest

I have a worksheet with dates across the top with information relevent to
that date beneath. What I wish to do is transfer the information for todays
date only to another sheet that will update itself as the date changes.Can
anyone help.
 
Hi KandK

You can use this formula for the cell value in row 2 with the dates in row 1
Change this range to yours
Sheet1!$A$1:$J$400

=HLOOKUP(TODAY(),Sheet1!$A$1:$J$400,2,FALSE)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to transfer the data from userform to spreadsheet for specific dates 0
VBA to automatically cut, paste entire row based on date input and delete row 0
Transfer only information under todays date 1
Transfer data relevent to date 7
Excel UPPER function 1
Conditional formatting dates 3
Excel Date Setting 1
data associated with latest date 5

Back
Top