software

Does anybody know of a function, formual, or macro on Excel 2003 that I can
use so that my spreadsheet will automatically erase information in certain
cells on certain days? For example: On May 25th I will enter quot;YESquot; in cells
B5 and B6. I want cell B5 to automatically revert to a blank cell on June
5th and cell B6 to revert to a blank cell on June 11th. There aren't many
things that you can NOT do with Excel. Did I find one?

No. You could put a procedure in your workbook_open event

if date=sheets(quot;yourmastersheetquot;).range(quot;a1quot;) then _
sheets(quot;sheettochangequot;).range(quot;b5quot;)=quot;quot;--
Don Guillett
SalesAid Software

quot;Conker10382quot; gt; wrote in message
...
gt; Does anybody know of a function, formual, or macro on Excel 2003 that I
gt; can
gt; use so that my spreadsheet will automatically erase information in certain
gt; cells on certain days? For example: On May 25th I will enter quot;YESquot; in
gt; cells
gt; B5 and B6. I want cell B5 to automatically revert to a blank cell on June
gt; 5th and cell B6 to revert to a blank cell on June 11th. There aren't many
gt; things that you can NOT do with Excel. Did I find one?
Don,
Thanks for the speedy reply. Unfortunately I am a master at Formulas and
Functions, but Macros are new territory for me. I don't expect you to take
up your day explaining to me how to enter a procedure in my workbook_open
event (unless it's really simple). Is there a training course offered by
Microsoft that could teach me this? When it comes to Excel, I'm willing to
learn everything there is to know.

quot;Don Guillettquot; wrote:

gt; No. You could put a procedure in your workbook_open event
gt;
gt; if date=sheets(quot;yourmastersheetquot;).range(quot;a1quot;) then _
gt; sheets(quot;sheettochangequot;).range(quot;b5quot;)=quot;quot;
gt;
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Conker10382quot; gt; wrote in message
gt; ...
gt; gt; Does anybody know of a function, formual, or macro on Excel 2003 that I
gt; gt; can
gt; gt; use so that my spreadsheet will automatically erase information in certain
gt; gt; cells on certain days? For example: On May 25th I will enter quot;YESquot; in
gt; gt; cells
gt; gt; B5 and B6. I want cell B5 to automatically revert to a blank cell on June
gt; gt; 5th and cell B6 to revert to a blank cell on June 11th. There aren't many
gt; gt; things that you can NOT do with Excel. Did I find one?
gt;
gt;
gt;

right click the excel icon in the upper LEFT of your screen next to
FILEgt;view codegt;play around

--
Don Guillett
SalesAid Software

quot;Conker10382quot; gt; wrote in message
...
gt; Don,
gt; Thanks for the speedy reply. Unfortunately I am a master at Formulas and
gt; Functions, but Macros are new territory for me. I don't expect you to
gt; take
gt; up your day explaining to me how to enter a procedure in my workbook_open
gt; event (unless it's really simple). Is there a training course offered by
gt; Microsoft that could teach me this? When it comes to Excel, I'm willing
gt; to
gt; learn everything there is to know.
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; No. You could put a procedure in your workbook_open event
gt;gt;
gt;gt; if date=sheets(quot;yourmastersheetquot;).range(quot;a1quot;) then _
gt;gt; sheets(quot;sheettochangequot;).range(quot;b5quot;)=quot;quot;
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Conker10382quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Does anybody know of a function, formual, or macro on Excel 2003 that I
gt;gt; gt; can
gt;gt; gt; use so that my spreadsheet will automatically erase information in
gt;gt; gt; certain
gt;gt; gt; cells on certain days? For example: On May 25th I will enter quot;YESquot; in
gt;gt; gt; cells
gt;gt; gt; B5 and B6. I want cell B5 to automatically revert to a blank cell on
gt;gt; gt; June
gt;gt; gt; 5th and cell B6 to revert to a blank cell on June 11th. There aren't
gt;gt; gt; many
gt;gt; gt; things that you can NOT do with Excel. Did I find one?
gt;gt;
gt;gt;
gt;gt;
Thanks Don, you're suggestions worked great!

quot;Don Guillettquot; wrote:

gt; right click the excel icon in the upper LEFT of your screen next to
gt; FILEgt;view codegt;play around
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Conker10382quot; gt; wrote in message
gt; ...
gt; gt; Don,
gt; gt; Thanks for the speedy reply. Unfortunately I am a master at Formulas and
gt; gt; Functions, but Macros are new territory for me. I don't expect you to
gt; gt; take
gt; gt; up your day explaining to me how to enter a procedure in my workbook_open
gt; gt; event (unless it's really simple). Is there a training course offered by
gt; gt; Microsoft that could teach me this? When it comes to Excel, I'm willing
gt; gt; to
gt; gt; learn everything there is to know.
gt; gt;
gt; gt; quot;Don Guillettquot; wrote:
gt; gt;
gt; gt;gt; No. You could put a procedure in your workbook_open event
gt; gt;gt;
gt; gt;gt; if date=sheets(quot;yourmastersheetquot;).range(quot;a1quot;) then _
gt; gt;gt; sheets(quot;sheettochangequot;).range(quot;b5quot;)=quot;quot;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Don Guillett
gt; gt;gt; SalesAid Software
gt; gt;gt;
gt; gt;gt; quot;Conker10382quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Does anybody know of a function, formual, or macro on Excel 2003 that I
gt; gt;gt; gt; can
gt; gt;gt; gt; use so that my spreadsheet will automatically erase information in
gt; gt;gt; gt; certain
gt; gt;gt; gt; cells on certain days? For example: On May 25th I will enter quot;YESquot; in
gt; gt;gt; gt; cells
gt; gt;gt; gt; B5 and B6. I want cell B5 to automatically revert to a blank cell on
gt; gt;gt; gt; June
gt; gt;gt; gt; 5th and cell B6 to revert to a blank cell on June 11th. There aren't
gt; gt;gt; gt; many
gt; gt;gt; gt; things that you can NOT do with Excel. Did I find one?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

glad to help you learn how to do it yourself

--
Don Guillett
SalesAid Software

quot;Conker10382quot; gt; wrote in message
...
gt; Thanks Don, you're suggestions worked great!
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; right click the excel icon in the upper LEFT of your screen next to
gt;gt; FILEgt;view codegt;play around
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Conker10382quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Don,
gt;gt; gt; Thanks for the speedy reply. Unfortunately I am a master at Formulas
gt;gt; gt; and
gt;gt; gt; Functions, but Macros are new territory for me. I don't expect you to
gt;gt; gt; take
gt;gt; gt; up your day explaining to me how to enter a procedure in my
gt;gt; gt; workbook_open
gt;gt; gt; event (unless it's really simple). Is there a training course offered
gt;gt; gt; by
gt;gt; gt; Microsoft that could teach me this? When it comes to Excel, I'm
gt;gt; gt; willing
gt;gt; gt; to
gt;gt; gt; learn everything there is to know.
gt;gt; gt;
gt;gt; gt; quot;Don Guillettquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; No. You could put a procedure in your workbook_open event
gt;gt; gt;gt;
gt;gt; gt;gt; if date=sheets(quot;yourmastersheetquot;).range(quot;a1quot;) then _
gt;gt; gt;gt; sheets(quot;sheettochangequot;).range(quot;b5quot;)=quot;quot;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Don Guillett
gt;gt; gt;gt; SalesAid Software
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Conker10382quot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Does anybody know of a function, formual, or macro on Excel 2003
gt;gt; gt;gt; gt; that I
gt;gt; gt;gt; gt; can
gt;gt; gt;gt; gt; use so that my spreadsheet will automatically erase information in
gt;gt; gt;gt; gt; certain
gt;gt; gt;gt; gt; cells on certain days? For example: On May 25th I will enter quot;YESquot;
gt;gt; gt;gt; gt; in
gt;gt; gt;gt; gt; cells
gt;gt; gt;gt; gt; B5 and B6. I want cell B5 to automatically revert to a blank cell
gt;gt; gt;gt; gt; on
gt;gt; gt;gt; gt; June
gt;gt; gt;gt; gt; 5th and cell B6 to revert to a blank cell on June 11th. There
gt;gt; gt;gt; gt; aren't
gt;gt; gt;gt; gt; many
gt;gt; gt;gt; gt; things that you can NOT do with Excel. Did I find one?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;