Copying rows to certain worksheet

Closed
help - Jul 14, 2015 at 12:37 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jul 15, 2015 at 07:50 AM
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 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Jul 15, 2015 at 07:50 AM
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.
0