Create Huge Editable Database in User Friendly Way

Hi everyone,

I have been away from Excel for a bit so I'm trying to get my bearings again. I am taking a workbook from someone else and trying to update it. As it currently stands, I will receive an order from my boss and it contains information such as part numbers affected, dates, and various other things.





Is this layout manageable or should I rethink how I want to present this information?



I have a "Dashboard" which will show the orders and statuses such as completed, date, notes which I would like to pull from the database sheet.

I have an "Add" sheet where I can copy/paste the cells from my boss' order sheet. There is a macro button that will copy the data to the database, then clear the add sheet so I can start fresh when he sends me another order.

I have the database sheet which stores the info from the "Add" sheet. This will just keep building over time.

The main sheet I'm having issues with and confusing myself over an answer is the "Update" sheet. I would like to type in any order # that is in my database and have it populate all of the part #s and other info, but ALSO edit information there? I am making machining programs and I'd like to type in the order number, see all part#s affected, and set in a drop down box that I have completed, not completed, each program. Is there a way to lookup multiple rows/columns at once AND edit this info? Or should I restructure?


Hopefully this made any kind of sense. Thank you for reading.

*PS*
I am just posting for the first time and it is telling me when I upload my workbook to upload and scroll down to "Go Advanced" but I'm seeing nothing of the sort. If I didn't upload this properly, let me know.

I have a new idea after talking to myself through my lunch break.

I still need help "Looking up" multiple rows at once up to the next blank row.

As for "editing" the database. I could use the vba to cut the data I want out of the database, paste it to the edit sheet, and then click a button that cuts it and pastes it right back to the database. I don't know how to do that, finding a set of data through vba looking for the order number and subsequent part numbers, but I'm sure it can be done.

I will look into this for awhile and see what happens.

Hi Torachan. Thank you for checking this out. The only reason I have the table set that way is due to the formatting that I receive these new orders from another department. Is there anything I can do about that myself besides manually deleting the column?

Torachan,

I think something is wrong with my browser because I've responded multiple times and I come back and see there is no response to yours. Here is what I've done. I have done everything in vba to get my desired results. I have attached the workbook with the macros in case anyone is interested in what worked for me. I am not done with this workbook by any means, but I'm past the original part that I came here for. Thank you!

I just got in this morning and am looking at the workbook you attached. I am blown away! This is really cool. I'm looking at everything trying to understand how you did it and think it's great. Is this UserForm a template or did you specify with code the dimensions and amount of text boxes? I love what you have an wonder if I could make one with fewer boxes in a different project.

I will be looking through this, and I deeply appreciate you looking at this project with me.

I just found how to create a userform like you did and I see the toolbox that comes up with it! Very cool.