I am working between two sheets. 1. Raw Data sheet 2. Tempe.
Could you please help me create a VB script that will look in the Raw data sheet column C for any value that says Tempe
Then check and see if the date in Raw Data Sheet Column D is within the same date range listed in the Tempe worksheet between Cells B2 and B738.
If the date is within range then find the value(Campaign name) in Raw Data Sheet, Column A and check if it has already exists in Tempe sheet Range F1:Q1. If it does not exist there already put the Value (Campaign name) posted in the Raw Data sheet and post it in the Tempe sheet Range F1:Q1 in the first available column.
I have attached the sheet I am working with for reference
I appreciate all the input here!