Copying rows to certain worksheet

[Closed]
Report
-
Posts
1318
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 20, 2021
-
Hello,
I think i can accomplish this without a macro but can figure it out. I have a project list on sheet1, I would like to copy a projects row to a persons sheet, if column(x) contains their name.
Thanks for the help


1 reply

Posts
1318
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 20, 2021
238
Hello Help,

The information that you have supplied is a little scant. Could you elaborate a little more please.

- How many "Persons" and hence how many individual sheets?
- How many columns and rows?

I suspect that there may be a fair amount of data so I think that you will need to use macros.

It would be most helpful if you could upload a sample of your work book showing your inputs and expected results. You can upload a sample by using a free file sharing site such as DropBox or ge.tt (but please be careful with any sensitive data). Someone should then be able to help you.

Cheerio,
vcoolio.