Hello!
I have a workbook which contains 3 sheets. It's purpose is to contain a current and historical record of items and their respective attributes. You will find a sample attached. The layout is basically this: I have an Entry Page (which is for entering new/updated information of items), a Current List (which displays the current information of items), and a Historical List (which displays historical information of items).
What I'm trying to achieve is to set up a button/something on the Entry Page that would add new/updated information for an item to the Current and Historical Lists.
I'll explain it in more detail:
The workbook opens to the Entry Page. The first value to enter is the item Number.
If it's a new number (a number that is not yet listed in the Current List), the user would just continue adding the rest of the information, then hit the Submit button - and the information would be entered in numerical order into the Current and Historical Lists, and the data on the Entry Page cleared.
If it's a number already in the Current List, all the current information on the item would be displayed, and the user would be asked if they want to update the current item's information or just view it. If the user chooses to update, then upon making the changes and submitting, the updated information would be added to the Historical List, and the Current List would now display the latest update. And the Entry Page would be blank once more, for the next entry.
So! That's the plan - any help/advice is hugely appreciated! Thanks so much in advance!
Bookmarks