Need Macro code for Search, Copy & Paste?

hariexcel1987 Posts 2 Registration date Wednesday October 29, 2014 Status Member Last seen October 30, 2014 - Oct 30, 2014 at 09:37 AM

I have Two Excel sheets , In Sheet2: Database file(Row wise Data has been updated i.e only in A column- refer below

A1: Name
A2 : person name
A3: Company
A4 : Company name
A5: City
A6 : City place

A7:Blank cell
A8: Blank cell
A10 : Blank cell

A11 : Blank cell


A15: Name
A16 : person name

A17: Company
A18 : Company name

A19: City
A20 : City place

A21:Blank cell
A22: Blank cell

A24 : Blank cell

A25 : Blank cell


Sheet1: MIS Report (with the heading of the columns).

In Sheet1 -i have populated the headings like Name , Company, city etc.

**Name Company Title City Telephone State Mobile Country Email Area of responsibility Business focus**

Macro Requirement :

So here,i wanted to create a macro to search for all the same heading names and copy the next row data and paste into under respective headings in Sheet 1

Please do let me know if you have any questions on the same and Thanks a ton in Advance.

1. Like this i have 20000 rows in a A column , here now i wanted to search in a "Sheet2" with the heading name of Sheet1 (Ex :Name,Company )

2. copy the next row data and paste into sheet1 under respective headings 3.we should do Find NEXT until we copied all the data

Kindly help