If date = x, then capture data on row and move to new sheet

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

Guest

I am trying to create a function for the following:

If date = todays date or earlier
Then pull information in cells (a2, b2, and e2)
Place pulled information onto new sheet in same workbook

Is this possible? If so, any assistance would be greatly appreciated!

Shari
 
Hi Shari

Assuming the source data is on Sheet1, and that row 1 of Sheet2 contain
real Dates, then on Sheet2 cell A2 enter
=IF(A1<=TODAY(),Sheet1!A2,"")
Copy cross through the cells required.
 

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

COUNT rows on external sheet if between date range 3
Macro to create date when sheet opens and then remain static when 2
Copy Data from One Spreadsheet to Another ?????? 5
Pulling From Multiple Sheet 0
display date of today in cell X when number >0 in cell Y 2
Need conditional data from 1 sheet to populate another sheet 3
Today() and IF Function 6
Moving Column data formula 1

Back
Top