Hi,
Im new to VBA and have written some basic code previously but am really struggling with this task.
I have one spreadsheet with different products on each row, I want a macro to find the dates in both column G and I, and then open another spreadsheet, find the relevant product and then search for 6 months each side of the dates in column G and I from the first spreadsheet. If the serach finds a clash of dates in the second spreadsheet I then want both column G and I to be coloured red on the first spreadsheet to show there is a clash. I need the macro to search each line in the first spreadsheet as this will be added to constantly.
I have the VBA code to open the second spreadsheet but am totally stuck as how to perform the different searches.
Any help would be much appricated and gratefully recieved.
Many thanks.
Im new to VBA and have written some basic code previously but am really struggling with this task.
I have one spreadsheet with different products on each row, I want a macro to find the dates in both column G and I, and then open another spreadsheet, find the relevant product and then search for 6 months each side of the dates in column G and I from the first spreadsheet. If the serach finds a clash of dates in the second spreadsheet I then want both column G and I to be coloured red on the first spreadsheet to show there is a clash. I need the macro to search each line in the first spreadsheet as this will be added to constantly.
I have the VBA code to open the second spreadsheet but am totally stuck as how to perform the different searches.
Any help would be much appricated and gratefully recieved.
Many thanks.
