View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Export row depending on column to various sheets

First question(s): Do the other 5 sheets already have names on them that
appear (or will appear) on the master sheet? Or are you supposed to move new
names that appear on the master sheet (but don't exist on the others) onto
those sheets?

I am thinking that since you said only 5 names, and you have 5 other sheets,
that there is 1 name on each of the other sheets, and that all entries on the
Master sheet will have one of those 5 names associated with it.

Next question: when you get a match on a name and want to move the entry
from the master sheet to the appropriate sheet, does the data get placed in a
new row at the end of existing information on those sheets?

This is going to take a bit of VBA coding (a macro) and it will help if you
have a column on the Master sheet that the code can use to put a simple
marker, like an "X" into it to indicate that the information on that row has
already been moved or processed, unless there is some other way we can
clearly tell whether a should be copied without having to compare every row
of information on every sheet each time the process is run.


"Andrew C" wrote:

Stay with me, not a very good techical writer, will try to be clear.

I get a daily Excel spreadsheet with multiple columns.
Would like to set up a new workbook with the master sheet where I just add
the dailys into, plus have 5 sheets where the rows will be exported depending
on the names in column A, only 5 names.

So, I would like a workbook with 6 sheets, one sheet is The Master (Which is
updated daily) & 5 where the rows will be exported to from the master
depending on the name in column A.

If you need me to be more clear, let me know I will do my best. Also, the
clearer your answer the better, I sort of got thrown into this task & I have
no clue how to use Excel, learning as I go along.

Thanks.