Extracting Data

  • Thread starter Thread starter chinaprasad
  • Start date Start date
C

chinaprasad

Dear All,

I need a help on data extracting...

I have a data abt 12 col and 40 rows with header in each col.
the header like --- Inv no, Inv Dt, Customer Name, amount, chq no
Chq
date etc....

there are mutiple records (ie. rows) for a customer, i want to lis
all
the records / rows pertining to a customer and make report in a diff
worksheet.

I can do this using advance filter, but if i change the the custome
name resepective rows will not get changed dynamically,
again i have to do the whole process of advance filter..

cud u plz suggest same other method so that records are dynamicall
changes once i select the customer

Thanx in advance.

regds
CN
 
I don't like separating my data into different worksheets. I'd use
Data|filter|autofilter and filter to show whatever customer I wanted to see.

But if you really need to extract to new worksheets, I'd steal some code from
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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
some mvp may give an elegant solution. meanwhile
use a listbox and configure a procedure under
ListBox1_Click()
if you are intersted send a mesage to my email address removing xs in the
address
 
Back
Top