| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automate Spreadsheet
I have a spreadsheet that tracks instruments and their calibration due dates.
I'm trying to figure out the best way to do this. I want the caibration due dates to stand out so I know at least one week prior that certain instruments should be calibrated. I thought of setting up columns for Instrument, Serial No., Calibration Date and Calibration Frequency. Then set up a calculated column to calculate the due date. Then use conditional formatting to flag the instruments that are due. This list could get long. How can I automate this even more? Maybe set up a way of filtering out the instruments that are due with a macro. This list will get out of control over the years if I don't organize it well. Any suggestions? My boss wants me to just use Excel and not Access. I'm just thinking ahead. I know some people will tell me to use Access. Thank you, Karen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automate Spreadsheet
Hi Karen
Maybe this will help You can use EasyFilter to filter and copy to a new sheet/workbook The beta version can also filter on color http://www.rondebruin.nl/easyfilter.htm Another way is to use an Access data base and copy your data into Excel if you need it http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Karen" wrote in message ... I have a spreadsheet that tracks instruments and their calibration due dates. I'm trying to figure out the best way to do this. I want the caibration due dates to stand out so I know at least one week prior that certain instruments should be calibrated. I thought of setting up columns for Instrument, Serial No., Calibration Date and Calibration Frequency. Then set up a calculated column to calculate the due date. Then use conditional formatting to flag the instruments that are due. This list could get long. How can I automate this even more? Maybe set up a way of filtering out the instruments that are due with a macro. This list will get out of control over the years if I don't organize it well. Any suggestions? My boss wants me to just use Excel and not Access. I'm just thinking ahead. I know some people will tell me to use Access. Thank you, Karen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automate Spreadsheet
Thank you for your help - The company I work for blocks use out from
downloading anything like that. Any other suggestions? "Ron de Bruin" wrote: Hi Karen Maybe this will help You can use EasyFilter to filter and copy to a new sheet/workbook The beta version can also filter on color http://www.rondebruin.nl/easyfilter.htm Another way is to use an Access data base and copy your data into Excel if you need it http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Karen" wrote in message ... I have a spreadsheet that tracks instruments and their calibration due dates. I'm trying to figure out the best way to do this. I want the caibration due dates to stand out so I know at least one week prior that certain instruments should be calibrated. I thought of setting up columns for Instrument, Serial No., Calibration Date and Calibration Frequency. Then set up a calculated column to calculate the due date. Then use conditional formatting to flag the instruments that are due. This list could get long. How can I automate this even more? Maybe set up a way of filtering out the instruments that are due with a macro. This list will get out of control over the years if I don't organize it well. Any suggestions? My boss wants me to just use Excel and not Access. I'm just thinking ahead. I know some people will tell me to use Access. Thank you, Karen |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automate Spreadsheet
Hi Karin
Look on Debra's site for filter examples http://www.contextures.com/tiptech.html -- Regards Ron de Bruin http://www.rondebruin.nl "Karen" wrote in message ... Thank you for your help - The company I work for blocks use out from downloading anything like that. Any other suggestions? "Ron de Bruin" wrote: Hi Karen Maybe this will help You can use EasyFilter to filter and copy to a new sheet/workbook The beta version can also filter on color http://www.rondebruin.nl/easyfilter.htm Another way is to use an Access data base and copy your data into Excel if you need it http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Karen" wrote in message ... I have a spreadsheet that tracks instruments and their calibration due dates. I'm trying to figure out the best way to do this. I want the caibration due dates to stand out so I know at least one week prior that certain instruments should be calibrated. I thought of setting up columns for Instrument, Serial No., Calibration Date and Calibration Frequency. Then set up a calculated column to calculate the due date. Then use conditional formatting to flag the instruments that are due. This list could get long. How can I automate this even more? Maybe set up a way of filtering out the instruments that are due with a macro. This list will get out of control over the years if I don't organize it well. Any suggestions? My boss wants me to just use Excel and not Access. I'm just thinking ahead. I know some people will tell me to use Access. Thank you, Karen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save spreadsheet as web page | Excel Discussion (Misc queries) | |||
| How to handle multiple currencies with one spreadsheet | Excel Discussion (Misc queries) | |||
| Spreadsheet merging problems | Excel Worksheet Functions | |||
| Linkage data between two spreadsheet | Excel Worksheet Functions | |||
| Linking formula to external spreadsheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
