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