excel job sheet database

Hobbsie · 8 Dec 2014 at 13:45

Hi im currently making a basic job sheet for my dad's business.
Basically its making light fittings, when he gets an order he can use the drop down to select cable length/color/ceiling plate etc etc.
All seems to be good in excel now is there any software that i can export the data into a UI friendly database?
Or if theirs a cheap/free piece of database software out there that can turn the data into a nice looking UI?
hopefully i have not confused you :confused:

Thanks

Hobbsie · 8 Dec 2014 at 15:10

sorry you might of got a tad confused sorry my fault.
basically i have made an excel database with drop down menus, so if i select a product it auto fills in cells with relevant info.
Its very messy and was wondering if i can input the excel data into a nice looking database, so all you see is 5 drop down bars (for example) and the relevant info below them, not all the individual cells.
I see excel do VBA so i might look into that and see if that's what im after.

Hobbsie · 8 Dec 2014 at 15:35

looks like excel VBA is a winner maybe anyone else used it before it kinda looks simple?

Hobbsie · 8 Dec 2014 at 15:36

sorry spunkey i posted as you did

i didnt think of access tbh i will take a look.

Hobbsie · 8 Dec 2014 at 21:38

yes been having a play for a bit today im getting there bit of you tubing if i get stuck

but yeah looks like i might be fine with vba thanks for your input.

Hobbsie · 12 Dec 2014 at 17:26

thankyou for the advise