Transfer only information under todays date

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

Guest

I have a worksheet which has numerous entries under sequential dates. I want
to just transfer the information under todays date to a different sheet where
the information will change as the date changes. Can anybody 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)
 
You must log in or register to reply here.

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

Transfer data relevent to date 1
Excel UPPER function 1
How to transfer the data from userform to spreadsheet for specific dates 0
Excel How to get the number of days an item was opened from the today's date. 14
Excel Message box with days of month & date. 1
display date of today in cell X when number >0 in cell Y 2
Excel Display certain dates 9
VBA to automatically cut, paste entire row based on date input and delete row 0

Back
Top