Attemting to take a column of data and append it to multiple rows of data on another sheet

Hey everyone,

I have an issue where I have a column of data on one sheet and multiple rows on another sheet. I need to see if any of the data in the column are contained in each row and if it is not then append that data element to the end of the row for each row. I would be greatly appreciative for any ideas and examples on this issue. Thank you in advance.

Assume column A of Sheet1 contains the criteria data to be searched for in the multiple rows of sheet2.

Please Login or Register  to view this content.

Hey JLGWhiz,

That was absolutely perfect! The data that was in column A on the first sheet has to be appended to over a thousand rows on sheet 2; if found that is. I can't thank you enough. I can apply this to a quarterly audit and will save a lot of time. I'd name my next child after you if I planned to have more. LOL.. Seriously, thank you again.

Originally Posted by JamesJohnson31

Hey JLGWhiz,

That was absolutely perfect! The data that was in column A on the first sheet has to be appended to over a thousand rows on sheet 2; if found that is. I can't thank you enough. I can apply this to a quarterly audit and will save a lot of time. I'd name my next child after you if I planned to have more. LOL.. Seriously, thank you again.

You're Welcome,
Regards, JLG