Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to create a tracking sheet for mail recieved
I would like to creat an electronic tracking sheet for mail receied on a
daily basis |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to create a tracking sheet for mail recieved
Start a new workbook (in Excel). Name a sheet mail tracking. Name
some columns - Date received, Postmark Date, Recepient, Addressee, Size, Weight, Content, Check Amount - whatever you want to track. As you receive mail, fill in the corresponding columns with appropriate data. Come up with a designation for missing information, or items not applicable (check amount is not applicable when there's no check). Use a single row for each mail item. If you want, insert a row at the beginning of your sheet, call it ID or something. Use it to number mail items, so that you can look them up later if needed. Hope that helps. On Oct 12, 3:25 am, antoneil wrote: I would like to creat an electronic tracking sheet for mail receied on a daily basis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a tracking log | Excel Discussion (Misc queries) | |||
How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
How do I create a payment tracking spreadsheet? | Excel Discussion (Misc queries) | |||
How do I create a spread sheet for tracking batting statistics? | New Users to Excel | |||
How do you create a vendor tracking form for accounts payable pro. | Excel Discussion (Misc queries) |