| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I revert cells to blank automatically on spacific days?
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 "YES" 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I revert cells to blank automatically on spacific days?
No. You could put a procedure in your workbook_open event
if date=sheets("yourmastersheet").range("a1") then _ sheets("sheettochange").range("b5")="" -- Don Guillett SalesAid Software "Conker10382" wrote in message ... 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 "YES" 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I revert cells to blank automatically on spacific days?
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. "Don Guillett" wrote: No. You could put a procedure in your workbook_open event if date=sheets("yourmastersheet").range("a1") then _ sheets("sheettochange").range("b5")="" -- Don Guillett SalesAid Software "Conker10382" wrote in message ... 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 "YES" 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I revert cells to blank automatically on spacific days?
Thanks Don, you're suggestions worked great!
"Don Guillett" wrote: right click the excel icon in the upper LEFT of your screen next to FILEview codeplay around -- Don Guillett SalesAid Software "Conker10382" wrote in message ... 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. "Don Guillett" wrote: No. You could put a procedure in your workbook_open event if date=sheets("yourmastersheet").range("a1") then _ sheets("sheettochange").range("b5")="" -- Don Guillett SalesAid Software "Conker10382" wrote in message ... 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 "YES" 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I revert cells to blank automatically on spacific days?
glad to help you learn how to do it yourself
-- Don Guillett SalesAid Software "Conker10382" wrote in message ... Thanks Don, you're suggestions worked great! "Don Guillett" wrote: right click the excel icon in the upper LEFT of your screen next to FILEview codeplay around -- Don Guillett SalesAid Software "Conker10382" wrote in message ... 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. "Don Guillett" wrote: No. You could put a procedure in your workbook_open event if date=sheets("yourmastersheet").range("a1") then _ sheets("sheettochange").range("b5")="" -- Don Guillett SalesAid Software "Conker10382" wrote in message ... 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 "YES" 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OFFSET to include blank cells | Excel Worksheet Functions | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
| Blank cells represented in area charts | Charts and Charting in Excel | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Hybrid Mode
