| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Database or Access??
I have 3 sheets:
Sheet1: Stocks (many location, so partno can be repeated) A B C D partno Location Qty Value Sheet2: Sales (partno mostly repeated because of sales on many dates) A B C D partno Date Qty Value Sheet3: Backlog (partno unique) A B C D partno Date Avail Qty Value I need to combine the 3 sheets into one: (partno will be unique) A B C D E F G H partno stock qty stock value sales qty sales value Date avail backlog qty backlog value Which application is more suitable? Excel or Access? How to do it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Do I need Excel or Access for my database needs? | Excel Discussion (Misc queries) | |||
| access database (adodb)from excel vba | Excel Worksheet Functions | |||
| Excel graphs with Access database | Excel Discussion (Misc queries) | |||
| excel to get data from an access database | Excel Discussion (Misc queries) | |||
| Managing an Access Database from Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
