ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I would like to create a tracking sheet for mail recieved (https://www.excelbanter.com/excel-discussion-misc-queries/161862-i-would-like-create-tracking-sheet-mail-recieved.html)

antoneil

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

iliace

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





All times are GMT +1. The time now is 12:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com