Dynamic Variable identification

[Armado159]

Hi -

I am working on a project that sorts through data based on the headers located in the first row of the sheet. I need to be able to find values "source", "destination", and "totalbytes" and use the information in that column based on finding the header value. Once I find the column, I then need to be able to run a series of formulas against the columns values. Is this possible?

Thanks for the help. Let me know if anyone wants a sample set of data.

[Chippy]

This function returns the column number of the specified column header, or 0 if not found:

Please Login or Register  to view this content.

Call it like this:

Please Login or Register  to view this content.

and use columnNumber in your code.

[Armado159]

Great! Thanks! I'll test it a bit and let you know how it goes.

[Armado159]

Ok, the code returns the value for the column as expected. I have run into another problem though. I want to assign the value to a variable and use it in various calculations. Here is what I have tried...

Please Login or Register  to view this content.

returns error "Wrong number of arguments or invalid property assignment"