Thank you in advance for your assistance. I am extremely green at this.
I have some data E5:E67 in Sheet1 and want to copy and paste the values to a column in Sheet 2. The column in Sheet 2 is based on the date in Sheet 1 A2. In excel, I have no problem getting the lookup to get the correct cell address. However, I cannot figure out how to write the code to paste to a cell based on this variable cell address. Based on lookup, I know the correct cell to post this data is in cell w4, in Sheet 2, but this will change each time . The array which contains the hlookup data in rows 1&2 in sheet2.
I hope this is making sense.
Again, thank you in advance for your assistance.
I have some data E5:E67 in Sheet1 and want to copy and paste the values to a column in Sheet 2. The column in Sheet 2 is based on the date in Sheet 1 A2. In excel, I have no problem getting the lookup to get the correct cell address. However, I cannot figure out how to write the code to paste to a cell based on this variable cell address. Based on lookup, I know the correct cell to post this data is in cell w4, in Sheet 2, but this will change each time . The array which contains the hlookup data in rows 1&2 in sheet2.
I hope this is making sense.
Again, thank you in advance for your assistance.
