auto fill

[HSOLDO]

is there a way for cell references in commas to be modifiable?

for example:
cell A1 is : =indirect("B1")

Now I need to have the autofill to give me A2 =indirect("B2")

please note this is simplified task and I need "" or at least to return the same thing to indirect formula.

 

[Akashwani]

Hi,

Does this help?...

Excel Workbook
	A	B
1	test	test
2	test2	test2
3	Test3	Test3
4	0	*
5	test4	test4
Test

Ak

 

[HSOLDO]

yes it does

THANKS!!

 

[HSOLDO]

how would you make the last q7 to autofill to q8 if drag down.

=INDIRECT("'14-22 ("&INT((ROWS(D$4:D29)-1)/75)+1&")'!q7")