info from spreadsheet to few others

[menajordan]

I have this problem:
I have a sheet with few columns, one of them, route, have diferent values inside. I need to get a formula or so to send to a diferent page when that number is 1, or 2, or 3, etc., so I can divide that one sheet with everyone into it to a personal one for each person. Of course, I need to get the all line from the first page, I mind all the information from that specific trip.
Thank you for your help guys.
Ernie

[rylo]

Ernie

There are various ways to approach this.

1) Use advanced filter to send the data to the individual sheets. You can use code to do a one off, or loop through all output sheets.
2) Similar to above, but the code will create the output sheets from the raw data. Initiate the code either manually, or with an event.
3) You can use formulas to bring in the data. INDEX, MATCH etc. Depending on how much data you have, this could be a strain on resources.

Can you give more detail on your requirements so we can give more assistance.

rylo

[motown]

There must be something missing in my process. I've treid to use the advanced filter to do this, but it never seems to work. I always get an error that says "you can only copy data to a n active sheet.

[rylo]

Hi

You have to be on the output sheet when you invoke the advanced filter.

Say your data is on sheet1 in the range A1:C10, with headings in A1:C1

Your output is on sheet2, with the headings in A1:C1. Your criteria is on sheet2 in E1:E2.

Make sure you are on sheet2, then invoke the advanced filter. It will give the error when first raised, but ok through that until you get the range selection wizzard. Use that to set your ranges.

HTH

rylo