I need a macro that will do the following on the attached example.
Run down Column B and for every instance of 01|13 copy the adjacent isbn in column C.
For 01|13 entries paste the copied data as values into another workbook called Workbook 2 in cell A10, then A11 etc.
For 02|13 entries paste the copied data as values into another workbook called Workbook 2 in cell A60, then A61 etc.
For 03|13 entries paste the copied data as values into another workbook called Workbook 2 in cell A110, then A111 etc.
i.e. every time the month changes by 1 jump down to A60 then A110 then A160 etc.
Sometimes these ranges change so it would be helpful if the first cell for each month to be pasted into it is defined in the macro i.e. Range("A10").Select for example. Rather than just assuming the data will be 50 rows apart.
This is one sheet of a set and some sheets don't have 01|13 throught to 04|13 and there are other variations so the macro needs to be able to work out that if the number in B6 is 05|13 it needs to paste into A210.
I have given an example on sheet 2 of the attached example.
Many thanks.
Bookmarks