copying to another spreadsheet

  • Thread starter Thread starter bdh2004
  • Start date Start date
B

bdh2004

I have a table in spreadsheet x of 10 columns and 1000 rows. Afte
sorting by the entries in column a, I would like to copy row entrie
with the same column a entry to a specific location in spreadsheet Y.
E.g., the rows that have "oranges" in column a in spreadsheet x woul
be copied to a specific location in spreadsheet Y, under a heading o
"oranges". In the same vein, column a entries in spreadsheet x o
"pears" would be copied to spreadsheet y under the heading of "pears".
And so on. Is there any way to automate the copying of rows fro
spreadsheet x to spreadsheet y. Thank you for your consideration
 
You may want to look at Debra Dalgleish's site:

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

There are a couple of files you may want to steal from:

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

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb
 
Back
Top