Copying Select Data From one EXCEL Sheet to Another

[kishor.gala]

Hope someone can help me with a EXCEL VB code for copying select data to separate spreadsheets.

I have a farily large spreadsheet (~5000 rows x 200 columns). Column A has three string variables. For every value in Column A there may be up to 20 variables in Column B, and for every value in Column B there may be four to five variables in Column C.

I want a flexible code that searches (filters on) the first values in Columns A, B and C and copies the selected data (all 200 Columns) to a spreadsheet "variableA1_variableB1_variableC1." Then it increments to the next value in Column C and copies the data to a new spreadsheet "variableA1_variableB1_variableC2" until all values in Column C, B and A are are exhaused.

Right now I am using a macro that has the variables hard wired in the autofilter criteria statement, but the code is redundant and too long.

I want a code that searches and stores the varaibles without hard wiring the. I would appreciate any help that can be offered. I am a novice at programming at best. Thanks

- Kishor

[davesexcel]

http://www.excelforum.com/attachment...4&d=1173865150
Has an example of filtering and copying to another sheet
you can change the destination by altering the code so it copies to another workbook
I have enlarged the area to do that in the code below, Alt F11 gets you into the VBA editor

In the example workbook enter one of these words
CHEESE
OLIVES
pickles
rice
TOMATO
in the blue cell and click the button

[kishor.gala]

Thanks! I can work with it.