Copy Cells in a Row to Another Sheet if they are new (doesnt already exist in other sheet)

[heimk008]

Hello Brilliant Excel People,

I am not very experienced with VBA or Macros and need some help. I have a running list of activities based on 4 parent cells (Theme, Content, Title/Topic, and a concatenation of content and topic (normally hidden)). I also have a weekly calendar view where the activities are listed by day across the columns, based on the parent columns that match the running list.

I am trying to find a way where if what is entered in the parent cells in the running list sheet doesn't already exist in the weekly calendar view, they parent cells will be copied from the running list and pasted in the first empty row of the weekly calendar view.

I have attached a sample file with visuals of what i would like to see.

Please help!

[1aaaaaaaaaaaaaaa]

Hi,

Will see if I can take a crack at this when I get home in a few hours.

[1aaaaaaaaaaaaaaa]

Hiya,

Hope you are well, I was able to code a solution that I think will work for you.

I would save your workbook as macro enabled (.xlsm) and paste the following code in the Sheet2 (1. Master Content List) code module.

I will also attach the workbook I used to test for reference.

Please Login or Register  to view this content.

[heimk008]

The code worked perfectly!! Thank you so so much! You saved me so much time and you saved my team a lot of confusion.

[1aaaaaaaaaaaaaaa]

You're very welcome, I'm glad I could help please mark this thread as solved if your issue is resolved

[heimk008]

Does the thread look solved now? I thought I changed it last week.

thanks