Find cell value on master sheet and update range or add if not found

[ssteines]

Hi,

I have a macro that will copy row data from one worksheet to another Master worksheet (Job_Breakdown_Log). What I would like to do is either add another macro or update the current one to loop through the data on the Active Worksheet starting in row P57 and either update the cell values on the Master worksheet or add as a new line if it is not already there. This would be based on cell values in column A on the Master worksheet. I was going to try and paste links but I couldn't figure out how that would work?

Here is the code I have so far

Please Login or Register  to view this content.

[jolivanes]

Try this on a copy of your workbook because I don't know if I understand your requirement right.
Change references where required.

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

[ssteines]

Thank you AlphaFrog -- that appears to work perfectly!!

[ssteines]

I do have a question after testing this further, when I run the macro the row below is highlighted on the Job_Breakdown_Log. When I run the macro again it skips a line, how can I make it go to cell A1 or something and not have that blank row?

I have tried this but I get an error?

Please Login or Register  to view this content.

[AlphaFrog]

My guess is that "row below" that is highlighted is not empty. The last cell in column P maybe has a space character in it that makes it look empty but it's not.

[ssteines]

You are right there is a formula in it that returns "", is there a way to update that?

[AlphaFrog]

Please Login or Register  to view this content.

[ssteines]

Awesome - that did it, thank you for your prompt reply!!

[AlphaFrog]

You're welcome. Thanks for the feedback.