Match Common Variable Across Sheets and Copy a Variable

Hello,

I am hoping to get some assistance on a problem that will otherwise require a lot of manual entry and time (~10,000 entries), and I was thinking that a macro code might be the easiest solution. I am new to Excel and have very little experience writing macro code and was hoping that I will be able to get some help here.

I have two sheets that have different information for a set of patients. I need to insert one variable in Column C of Sheet 2 into Column Z of Sheet 1. Unfortunately, all of the patients in Sheet 2 are not in Sheet 1, but all of the patients in Sheet 1 are in Sheet 2, thus a simple ordering of the patients by their IDs and copying and pasting the columns will not work.

The basic layout of Sheet 1 is:
Column A Patient ID Column C ... Column Y
junk 123456 junk junk
junk 234567 junk junk

The basic layout of Sheet 2 is:
Column A Patient ID Column C
junk 123456 Variable x
junk 112345 Variable y
junk 234567 Variable z

The desired outcome will be:
Column A Patient ID Column C ... Column Y Column Z
junk 123456 junk junk Variable x
junk 234567 junk junk Variable z

Thank you in advance for the help!

Please Login or Register  to view this content.