|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
October 1st, 2009, 05:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
"indirect" formula reference
Hi,
How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando 
|
|
#2
October 1st, 2009, 05:59 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
There are quite a few ways. Here's one:
=INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message news  Hi, How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando
|
|
#3
October 1st, 2009, 06:05 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Try the below
=+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d" & ROW(A483)) If this post helps click Yes --------------- Jacob Skaria "ORLANDO VAZQUEZ" wrote: Hi, How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando
|
|
#4
October 1st, 2009, 06:08 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
That works fantastically. Can we also make the column changeable too ?
"ORLANDO VAZQUEZ" wrote: Hi, How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando
|
|
#5
October 1st, 2009, 06:13 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Can we make the column changeable too ?
"Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message news Hi, How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando
|
|
#6
October 1st, 2009, 06:13 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Can we make the column changeable too ?
"Jacob Skaria" wrote: Try the below =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d" & ROW(A483)) If this post helps click Yes --------------- Jacob Skaria "ORLANDO VAZQUEZ" wrote: Hi, How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando
|
|
#7
October 1st, 2009, 06:44 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
=INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!" & ADDRESS(Row(A483),COLUMN(D1)))
HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... Can we make the column changeable too ? "Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message news Hi, How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando
|
|
#8
October 1st, 2009, 06:55 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Hi Bernie,
How can I make this formula adjust for column movement too ? I tried to do the same as you did with Row by using COL but it doesn't work that way. Thanks for your help. Orlando "Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message news Hi, How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando
|
|
#9
October 1st, 2009, 07:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Jacob,
That worked great. Can I make the column likewise changeable so that if I move it down one and right one it also changes column ref ? "Jacob Skaria" wrote: Try the below =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d" & ROW(A483)) If this post helps click Yes --------------- Jacob Skaria "ORLANDO VAZQUEZ" wrote: Hi, How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando
|
|
#10
October 1st, 2009, 07:57 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Worked great! Thank you.
"Bernie Deitrick" wrote: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!" & ADDRESS(Row(A483),COLUMN(D1))) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... Can we make the column changeable too ? "Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message news
Hi,How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
