Finding and Setting Columns

Why don't you explain in plain English what you are trying to achieve, and then we can correct your code or perhaps suggest alternative methods.

Hey Stephen,

I'll take another shot at it. In a logical since what I want to do is find the column labelled "Alloc Oil" . Then from this column I want to select data under that heading. For example in the code I provided I am interested in finding the data in row 8 under the "Alloc Oil" column.

The reason I am using the find function is that sometimes these reports can arrive to me in a different format. With the colums not always being in the same order, however their labelling remains consistent.

So again I want to find specific columns, and then copy and paste data from specific rows under these columns.

That's better. Try this:

Please Login or Register  to view this content.

Thanks Stephen! It Works like a Charm