First of thanks to everyone on this board for helping me out the last couple of days. You all are very friendly and soooo knowledgable about Excel...I wish there was something I had to offer.
Well, in the last couple of days I am very proud to have created this spreadsheet with the help of this message board;
When you hit, say, the "Shipment Update" command button, it automatically inserts the current date, asks if they are current, selects the correct button, and asks what documents are missing and what actions where taken etc and inputs them into the appropiate field.
My question is, is it possible for excel to record on a seperate sheet each change or update made for each client and all the info that was changed. For instance, for the client ACG at the top,I already have a link to another page, and I would like a history of each update kept on that page.
Is this possible? Thanks for your help.
-Adam
Well, in the last couple of days I am very proud to have created this spreadsheet with the help of this message board;
reporting check sheet.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Client | Rpts.Required | DateChecked | Current? | MissingDocument | Action | ActionLetterSent | SpecialCommentsFromClient | ||
2 | ACG | Shipments | 2/20/2004 | jhgjyg | hgfghf | None | ||||
3 | ||||||||||
4 | ACMInc. | Shipment | 2/20/2004 | Current | Current | None | ||||
5 | Bulk | 2/20/2004 | Current | Current | None | |||||
6 | Storage | 2/20/2004 | Current | Current | None | |||||
7 | ||||||||||
8 | AlexanderInternational | Storage | 2/20/2004 | Current | Current | None | ||||
9 | AmericanPortServices | Storage | 2/20/2004 | Current | Current | None | ||||
10 | ||||||||||
11 | AremiDistrubuidora | Shipments | 2/20/2004 | ytu | tyuty | None | ||||
12 | Storage | 2/20/2004 | Current | Current | None | |||||
13 | ||||||||||
14 | BruceAlbrightAgency | Storage | 2/20/2004 | Current | Current | None | ||||
15 | Bulk | 2/20/2004 | Current | Current | None | |||||
Sheet1 |
When you hit, say, the "Shipment Update" command button, it automatically inserts the current date, asks if they are current, selects the correct button, and asks what documents are missing and what actions where taken etc and inputs them into the appropiate field.
My question is, is it possible for excel to record on a seperate sheet each change or update made for each client and all the info that was changed. For instance, for the client ACG at the top,I already have a link to another page, and I would like a history of each update kept on that page.
Is this possible? Thanks for your help.
-Adam