amsdowns
Board Regular
- Joined
- Dec 29, 2008
- Messages
- 73
On my main page I have a dropdown list. When the user finds their name, a group of cells refrence their info from the main spreadsheet by way of Vlookup formulas....This provides them with a quick window to their specific information.
Now the workbook is shared so multiple users can access their data at once.
An annoying thing is that if one user looks at their data, saves and leaves the page, the next user who comes in will see the prior user's information.
I want each user to have a fresh clean sheet when they first enter and not see the leftovers of the prior user's search.
BUT.....I don't want to use macro.
My users always forget to enable macros when they open the spreadsheet, so I just need a formula that will clear all the cells.
I know, I know, formulas can't affect other cells, however I can include this formula in with the Vlookup formulas to clear out the cell... I just don't know what the trigger would be. I thought maybe time (like give them 30 seconds to view, then bling...it would clear out...I also thought maybe if I instructed them to type "C" into a cell and included an "IF" formula in with the Vlookups, that that would clear it....but they would'nt do it... it has to be super-easy for them.
SO, without using macro, what formula would you suggest I use to clear a cell when they are done looking at it?
Now the workbook is shared so multiple users can access their data at once.
An annoying thing is that if one user looks at their data, saves and leaves the page, the next user who comes in will see the prior user's information.
I want each user to have a fresh clean sheet when they first enter and not see the leftovers of the prior user's search.
BUT.....I don't want to use macro.
My users always forget to enable macros when they open the spreadsheet, so I just need a formula that will clear all the cells.
I know, I know, formulas can't affect other cells, however I can include this formula in with the Vlookup formulas to clear out the cell... I just don't know what the trigger would be. I thought maybe time (like give them 30 seconds to view, then bling...it would clear out...I also thought maybe if I instructed them to type "C" into a cell and included an "IF" formula in with the Vlookups, that that would clear it....but they would'nt do it... it has to be super-easy for them.
SO, without using macro, what formula would you suggest I use to clear a cell when they are done looking at it?
