llabeoll

This may be hard for me to explain, so let me try my best.

I have 1 excel file with 2 sheets opened. Sheet1 and consignee_payment_report2.

CPR2 has a ton of columns and rows that I do not need, and Sheet 1 is a template I have generated to simplify this whole process. In my template I have fields that pull information and load it and do basic equations to figure out totals and such. What I want to do is on Sheet 1, define a hidden field variable of 2. This 2 will refer to what row on my CPR2 sheet I want to pull my information from. So all my function could read =consignee_payment_report2!COLUMN_LETTER(VARIABLE)

So as opposed to going through each field I have on my template and editing which column and number I want my information to be from, I can just have default functions with the column letters (seeing as the information on CPR2 never changes columns) and be able to just plug in my variable of which row I want to use and that completes all the other functions.

I hope this makes sense. I would like the variable to be able to be written somewhere on Sheet1 to make it quick and easy to change. Any help would be greatly appreciated.

Pizentios

sound like you could use a loop. Instead of having to input the row number.

have any code that you've tried?

__________________
Profanity is the one language that all programmers understand.

Check out my Blog <---updated Nov 30 2007!

llabe0ll

I have tried just the function that says this:

=consignee_payment_report2!C(B1)

I have tried several variation of that. I want to use Column C from my CPR2 page, but declare which row as a variable from my template Sheet1.

Pizentios

i take it that you wrote that function? It would probably be easier for me to understand your problem if you posted code.

__________________
Profanity is the one language that all programmers understand.

Check out my Blog <---updated Nov 30 2007!

llabe0ll

I do not have any code, all I have are functions. I want to be able to do this through functions, if at all possible.

Pizentios

well, since i can't find any reference to the function your using on google, or the microsoft excel site, somebody must have written it. The function probably doesn't take any arguments, which is why none of your variations worked.

You'll probably end up having to edit the function that your trying to use, so that it will take an var for the row.

Here's a link to a tutorial about writing functions in excel: http://www.exceltip.com/st/Writing_Y...Excel/631.html

there are several pages like that if you google "writing functions in excel".

__________________
Profanity is the one language that all programmers understand.

Check out my Blog <---updated Nov 30 2007!