VB to copy cell value in sheet1 to cells in sheet2 if criterion met

[cameron213]

This following is just an example:

In sheet1 I have 4 columns; Name, Age, *** and Job.

Sheet2 has three columns; Name, Age and Job.

What I need is VB that will check the *** column from Sheet1 and when it is Male, the Name, Age and Job fields from that row are copied into the cells in Sheet2.

It's been a while since I've worked with VB and I am a bit rusty. Having a hard time figuring it out.

[Mumps1]

Try:

Please Login or Register  to view this content.

[cameron213]

Try:

Please Login or Register  to view this content.

What is the best way to invoke it so that it doesn't copy itself over and over?

[Mumps1]

Assuming that Sheet2 has headers in the first row, try:

Please Login or Register  to view this content.

[cameron213]

Assuming that Sheet2 has headers in the first row, try:

Please Login or Register  to view this content.

Works very well except when one of the cells is empty and then instead of leaving it empty on sheet2 it messes up the order

[Mumps1]

When you say that one of the cells is empty, do you mean one of the cells in column C? Could you post a copy of your file? This way it would be easier to see how your data is organized.

[cameron213]

When you say that one of the cells is empty, do you mean one of the cells in column C? Could you post a copy of your file? This way it would be easier to see how your data is organized.

test.xlsm


I hope I attached the file correctly.

In this example I have Age in column C. I didn't specify an age for a person named John. When I click the Report button it copies the cell data to Sheet2. However, it shows John with the age of the person below him.

[Mumps1]

OK. I have to go out now. I'll get back to you tomorrow morning.

[Mumps1]

Hi Cameron. Try the attached file.

[cameron213]

Hi Cameron. Try the attached file.

Works very well. I've modified it a bit to fit my needs.

Thanks for your help.

[Mumps1]

My pleasure.