First of all I apologize for reposting the same question, but since I had no responses I thought I may needed to re-iterate my qestion:
There are two spreadsheets - one I get from Customer, and second is my template. From the customer spreadsheet Data are in fixed columns but it can be in any rows. In my Template I have Headers for things like Name. Phone #, Address, Date, etc. starting from cell A1, A2,....and onward! In the spreadsheet sent by customer has Name fields in Col. A, and the actual name is in Col B but same row. For example, cell A2 says "Name" and cell B2 says "Bill Ford". Now, in my template, right under cell A1, where it says "Name", I want excel to automatically populate "Bill Ford" in cell A2. That is all I would need help with to begin with. Any help will be greatly appreciated. Thank you.
There are two spreadsheets - one I get from Customer, and second is my template. From the customer spreadsheet Data are in fixed columns but it can be in any rows. In my Template I have Headers for things like Name. Phone #, Address, Date, etc. starting from cell A1, A2,....and onward! In the spreadsheet sent by customer has Name fields in Col. A, and the actual name is in Col B but same row. For example, cell A2 says "Name" and cell B2 says "Bill Ford". Now, in my template, right under cell A1, where it says "Name", I want excel to automatically populate "Bill Ford" in cell A2. That is all I would need help with to begin with. Any help will be greatly appreciated. Thank you.
