Find, Copy, and Paste cells values to another Spreadsheet.

sanmisds1

Board Regular
Joined
Jun 28, 2005
Messages
54
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.
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,336
Members
412,718
Latest member
dragosm
Top