Hey guys,
Well I’m fairly noob when it comes to using excel. I can use it just fine to make tables but know none of the codes, so I thought I'd find a forum for some guided learning!
My aim:
My work has a word document which contains some 76 pages of data which would have been much better off being saved on a spreadsheet. I am now trying to rectify that in such a way that we have an easily accessible and usable interface when updating the data.
From the first sheet of the spreadsheet we will need to do the following:
- View last style code input.
View last date of input.
View last user who input.
Select which sheet the data will be saved to using a dropdown box (in alphabetic order) or using an auto-complete box (which would be better if possible).
If the sheet doesnt exist already then a button to add a new sheet if required (This adds the sheet name to the dropdown boxes also).
Input style code (example xxxx7050x)
Input box for details.
Input box for user.
Another input box for further details.
Input for $ price
Input for £ price
Button to output all the data to the selected sheet plus the date and time.
List box listing all previously used codes (ignoring the letters before the number but not any after i.e. 7050x) in descending order (highest number at top) along with which sheets they appear on.
The list box would appear as follows:
- 7050x sheet1, sheet2, sheet9, sheet53
7050 sheet5, sheet6
7049y sheet11, sheet12
7049x sheet9, sheet43
7048 sheet23, sheet69
If possible, it would also be handy to have a quick jump to a sheet. So a dropdown box of sheet names and a button to action the jump. This is to save from trying to find each sheet manually.
All other sheets:
- Table of output data in descending order. (latest at the top)
Date & time – Style No. – Description – User – Further details - $ - £
The need for all this is so that the less technologically savvy will be able to update the sheets without having to faff about and probably cause problems and lose data.
I've attached an example of what I want to achieve.
Thanks in advance for any and all help. It'll be greatly appreciated
Bookmarks