Data extraction question.

  • Thread starter Thread starter Brendan
  • Start date Start date
B

Brendan

Hello all,

My problem relates to extracting information from a system generate
worksheet, providing the following rows and columns:


Part no. // w/house // qty
ABCDEF // VHO // 123
// QLD // 653
// WA1 // 333

The format that the information is displayed in shows one instance o
the part number in column A for (upto) several warehouses around th
country in column B and column C displaying the quantity available i
each. (// = new cell). At any time there could be upto 300 part number
serving the seven warehouses.

The problem relates to the extraction of information from eac
warehouse into a new 'display sheet' where not all warehouses ar
required to be accounted for and shown. In continuing the part number
for each instance of a warehouse, I have tried to do a vlookup. Th
only result I can obtain is equal to the first instance for the par
number on each occassion.

The display sheet is required to show the part number, warehouse an
quanity on a new line. Pricing, descriptions etc are added later t
complete the form.

The solution I require is to view the part number in column A, relat
it to specific warehouse in column B and extract the qty from colum
C.

Sorry for the long winded question. Thanks in advance for you
responses.

Brenda
 
Brendan,

Have you tried to use a pivot table on the data (data, pivot table).

It seems that the correct use of the page fields may give you th
results you are after.

If you have not used pivot tables before and online help doesn't, the
post back
 
Back
Top