View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macropod
 
Posts: n/a
Default Delete row by time/date?

Hi JP,

Do you want to actually delete the entire row, nullify its contents, or just
exclude it from a calculation?

If you want to:
.. delete the row, you'll need a clock-driven macro;
.. nullify the row's contents, you could use a formula to change numbers to
text; or
.. exclude the row from a calculation, you could use a formula to ignore that
row,
at a certain date/time. You can also create formulae to test for a
'complete' entry against different items for exclusion purposes.

Cheers


"JPaterson" wrote
in message ...

I'm working on a project that's quite large, and I would like to know if
it's possible to have Excel remove a column at a certain time and date.

For example, if part of my worksheet has a row with an item and a
status I call "Incomplete", it's because that part of the project isn't
finished. Once I finish it, it updates to "Complete", and then I'll
remove it. However, if I want to have that row removed at a certain
time, is there a function that'll allow me to do this? If not, what
about a macro?


--
JPaterson
------------------------------------------------------------------------
JPaterson's Profile:

http://www.excelforum.com/member.php...o&userid=33967
View this thread: http://www.excelforum.com/showthread...hreadid=537543