Search and destroy subroutines

Hello again ExcelForum friends!

Lately I've been using excel to copy web pages and then run a macro to turn it into a usable set spreadsheet of data but the paste results keep slightly shifting cell locations. Would it be possible to do something like the following?

Here is a Sample.xlsx file to keep us on the same page.

I was thinking a function SearchCells() and it would work something like SearchCells("Sample", 1) would return the cell location "B4" and SearchCells("Sample", 2) would return the cell location "C4". SearchCells("Sample") would just default to first "Sample" found.

All help and suggestions appreciated!

Edit: Sorry about the bad title. Went in a slightly different route with the thread, choosing to start with 1 primary component rather than the whole problem.

This is what I have so far, but it is not yet complete:

Please Login or Register  to view this content.

I think I got the framework laid out, now to make it work.

Please Login or Register  to view this content.

Going to start a new thread with an appropriate title. Closing this one. Thanks all!

Follow this topic on http://www.excelforum.com/excel-prog...ml#post3785355