Copy Row to Sheet 2 if condition 'A' met, Copy Row to Sheet 3 if condition 'B' met etc....

[alip_123]

I am an excel beginner so need help.

I have 8 columns in Sheet 1 and hundreds of rows. In 'H' I have one of three different options 'Adam', 'Bob' and 'Chris'. I would like the entire row copied to Sheet 2 if Adam is chosen, entire row copied to Sheet 3 if Bob is chosen and Sheet 4 for Chris.

There are lots of rows of data to transfer across, so naturally I don't want gaps between rows in sheet 2,3,4 etc.

I don't wish to use an Auto Sort or Filter.

Is there an IF formula that will do this or a Macro?

I have no idea how to do these so if someone can help please do so step by step.

Thanks.

 

[patel45]

attach please a link to a sample

 

[alip_123]

I don't know how. Please advise. I'm an idiot sorry.