Reference

  • Thread starter Thread starter peter kjaersgaard
  • Start date Start date
P

peter kjaersgaard

Help will be highly appreciated !!!!

In my worksheet I have the following data coloumns

A:Production name - B:sale - C:contribution margin - D:producername

Data could be:
A:RUNDII - B:100 - C:50 - D:TH
A:BB II - B:75 - C:25 - D:LS
A:HG II - B:200 - C:100 - D:LS
A:PPPII - B:300 - C:150 - D:TH
A:KLIII - B:500 - C:200 - D:TH


I collect all the data in another worksheet where the reference is
"producername" because is unique. I want to have the productions made by TH
seperate in the new sheet and the productions made by LS seperate...
something like ex below

A:RUNDII - B:100 - C:50 - D:TH
A:PPPII - B:300 - C:150 - D:TH
A:KLIII - B:500 - C:200 - D:TH


A:BB II - B:75 - C:25 - D:LS
A:HG II - B:200 - C:100 - D:LS

This output in the new worksheet should seperate all the data by the
producer name. If its TH put in one place and if its LS direct it to another
area !!!

I can't find a function which works, because Excel usually use reference as
numbers.

Thanks in advance for your help
- Peter, Denmark
 
Dave,
Thanks for your help !!

I'm not sure that a pivot will be the solution because I don't want to make
summary of the data. I just want to have the data sorted according to
producername and at the same time keep all the info..... to put it down to
basics... Just copy the line to the new sheet but sorted by producername...
so that TH's productions goes to one place and LS's productions to
another....

Regards, Peter
 
Hi
if this is a one time effort you may try using Advanced filters (Data -
filter). You can define a different worksheet as target range.

Note: To make this work you may have to invoke Advanced filters from
the target sheet and select the source sheet in the dialog
 
Have you considered applying data|filter|autofilter and keeping the original
data in place.

You can filter on the producer you want and hide all the others.

By keeping all the data together, it'll make life a lot simpler. You can do
subtotals (after sorting), pivottables, charts, easier.

But if you want to copy those rows out to a new sheet, you could use some sample
code at Debra Dalgleish's site:

http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb
 
Back
Top