ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel worksheet problem (https://www.excelbanter.com/excel-worksheet-functions/209221-excel-worksheet-problem.html)

Troubled in excel.

Excel worksheet problem
 
I would Excel like to insert information into another work sheet in the same
work book only when dates are added.

Example: when filling out my finances in one work sheet, I want it to
automatically populate onto another sheet when date of purchase has been
filled in.
I would like it to also pull the information on what was purchased.


Ashish Mathur[_2_]

Excel worksheet problem
 
Hi,

Try this =if(date cell<"",specific action,"")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Troubled in excel." <Troubled in wrote in
message ...
I would Excel like to insert information into another work sheet in the
same
work book only when dates are added.

Example: when filling out my finances in one work sheet, I want it to
automatically populate onto another sheet when date of purchase has been
filled in.
I would like it to also pull the information on what was purchased.



All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com