Dynamic Cell Row and choose certain columns to Paste into a diff. ws or wb

[Ash3154]

I am searching for data which I just entered via INPUTBOX.

Searches for Data within Range(G7 and CA10000)

If the data is found then it copies that cellrow and range of Columns H thru K and Column S and Columns AC thru BZ into a diff. Worksheet or Workbook (Haven't Decided).

If this data is incorrect then , would like for it go back and search further.

Again it would paste and so on until I get the information which I need.

I have figured out how to do a search via VBA, But I am having trouble with getting that CellRow and those columns.

Also what I can't figure out -- If I do a search on MAC, I don't want it to find MACRO or If I search for a phone number 201 555 1212, I don't want it to find 212 555 1212 (Basically I need to do an exact search).

Thanks,
Ash