Thread
:
If date = x, then capture data on row and move to new sheet
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
Posts: n/a
If date = x, then capture data on row and move to new sheet
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.
--
Regards
Roger Govier
"Shari Jamison" <Shari
wrote in
message ...
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
Reply With Quote