Penny
I assume that the destination sheet is not always the same but is
dependent on the name in that certain column. So you have multiple
destination sheets. I further assume that you want the data put into that
sheet somewhere like maybe the first empty row. Is all the above correct?
If so, you would need VBA (macros) to do that for you. I can write that
for you but I would need more information. For instance, what do you want
to use as the trigger to execute that macro to move that one row? Maybe
when you enter something in the 9th column? Maybe when you click on a
button? Does the main sheet have only one row in which you enter data, then
you want that one row automatically moved to one of the destination sheets?
Or does the main sheet have many rows of data? Do you want that one row
moved or copied? Are the destination sheets named the names that are in
that one column? If not, can you provide a list of all the names and their
corresponding sheet names? If the main sheet has multiple rows of data, do
you want to move/copy all the rows? If not, what criteria can you provide
to select which rows to move/copy?
A lot of questions, I know. If you wish, send me a small file with a
sample of what you have and answers to all the above and I'll write up
something for you. If your data is proprietary just make up something.
Send me the file direct, not to the newsgroup. Attachments are frowned upon
in peer-to-peer newsgroups such as these. My email is
(e-mail address removed). Remove the "Cobia97" from this address. HTH
Otto
