Hi all,
I have column A that contains a list of various items. Next to it are
monthly totals of each item. After that is an empty column. In the
next column (lets assume I) there is another list of items and the
column after contains the total for each item (lets assume J). The
list in column I contains items that should be present in column A
(though not always).

Each item in column I needs to comapred to the list in the column A.
If a match is found then take the correspoding value from column J and
paste it in the next available cell corresponding to that item.

If a match is not found then go to the end of the list in column A,
find the next available cell in column A, paste item there and in the
next column, paste the corresponding total from column J.

Any ideas

Thank you in advance
Khurram