Copying a particular range of values from one sheet to another in excel

A

anoop_2000

PLEASE HELP

I have the following table in Excel.

code Name qty price value remarks

1 XX 2 2 4
1 YY 3 2 6
2 ZZ 1 2 2

The above is a sample. I have a table with over 200 records. I want t
move, say all records with the code 1 to a new sheet, code 2 to anothe
and so on. Is this possible with VBA.

Thank
 
D

Dave Peterson

Visit 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

or

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
 
M

Mark E. Philpot

Send me a sample sheet. Say, the first 10 lines. I will
write the code for you.


I need more info. Do you want the new sheetname to
be "Code 1" etc..
I just need to see where the cell references are. Are
there any blank cells (no data) in the table?

Do you want all data copied or just the data to the right
of the Code value?

If you have 200 codes, you will get 200 sheets plus the
original.


regards
Mark

Visit:
http://au.geocities.com/excelmarksway
 
Top