Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I'm trying to figure out what would work best for data entry and retreval.
On one work sheet I would have my vendor and product categories both of
these would be referenced to numbers. Column1(vendors) Column2(product categories) Acme would equal 1 Widgets would equal 1 One the second worksheet I would have the first 2 columns would be referenced to the numeric value of the other worksheet (trying to save on size) the balance of the columns would be model number, description, pieces per package, cost, sell, msrp, date entered, date edited. Column1(vendors) Column2(product categories) Column3(model number) Column4(description) Column5(cost) Column6(sell) Column7(date entered) 1 1 Column8(date edited) To enter the data the form would have 2 combo boxes that would be from column 1 and 3 on the first worksheet but would enter the integer value in columns one and two of the second worksheet. The balance would be text boxes. To look up data I would like to be able to use any of the of these columns - vendor, product category, model number and description to input the information into a quote sheet. Is this doable in Excel? I have tried several of the quote software that's available and nothing covers everything I need. Marc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A What-if scenario changing one figure to work out another | Excel Worksheet Functions | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Can't figure out why Macro wont work???? | Excel Worksheet Functions | |||
VBA Help, cant figure out why it dosn't work. | Excel Programming |