| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If date = x, then capture data on row and move to new sheet
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If date = x, then capture data on row and move to new sheet
Thank you so very much!! Problem solved!
Shari "Roger Govier" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
