Transfer data relevent to 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.
 
R

Ron de Bruin

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

Transfer data relevent to date 7
Transfer only information under todays date 1
VBA to automatically cut, paste entire row based on date input and delete row 0
Function to Return a Date Value Q 4
Date + relative number reference 3
Vlookup on Dates 6
data associated with latest date 5
Excel Date Setting 1

Top