Copy Range based on criteria

[papaexcel]

I am trying to copy a range of cells, based on a set of criteria that changes constantly.

In Column A, I have numerical values that are present every 10th cell. In columns B through D, I have various text data that corresponds to the number in Column A. So for example, in A50, I have the number 46975. In the range B50-D59, I have text data that goes with the number in A50.

Each day I run a few calculations and based on the number I get, I want to find the exact match in column A, then copy all the data in columns B through D that are related. So if my calculations result in 46975, I want to automatically copy over to another worksheet the range B50-D59.

Does any of that makes sense?

Thanks in advance!

[zbor]

Can you upload an example?

[papaexcel]

Sure,
Attached is an example. My data actually goes out to column I.

Thanks again for any help!!

[zbor]

something like this?

(I had problems with your workbook so I create new wth your data... so if you have problems might be your excel settings or something)

Book1.xls

[papaexcel]

Perfect!! Thanks a ton!