J
Jane
I have a datasource worksheet and output work sheets. I
want to want to link a cell in datasource work sheet on
the outputwork sheets base on a formula.
For example:
datasource work sheet
a10 Steve
a11 Male
a12 work at home
a13 Sue
a14 Female
a15 work at officev
a16 Mary
a17 Female
a18 work at office
on output1 work sheet
a1 1 (I create this value for used in formula)
a2 Steve
on output2 work sheet
a1 2 (I create this value for used in formula)
a2 Sue
Since I need to create >10 output work sheets base on one
datasource sheet, I need to have the a2's (on output
sheet) value base on a formula.
somthing like =datasource!a(10 + (value(a1)-1)*3)
What is the correct systex for this formula? or Any other
way to do it?
Thank you for your help!
Jane
want to want to link a cell in datasource work sheet on
the outputwork sheets base on a formula.
For example:
datasource work sheet
a10 Steve
a11 Male
a12 work at home
a13 Sue
a14 Female
a15 work at officev
a16 Mary
a17 Female
a18 work at office
on output1 work sheet
a1 1 (I create this value for used in formula)
a2 Steve
on output2 work sheet
a1 2 (I create this value for used in formula)
a2 Sue
Since I need to create >10 output work sheets base on one
datasource sheet, I need to have the a2's (on output
sheet) value base on a formula.
somthing like =datasource!a(10 + (value(a1)-1)*3)
What is the correct systex for this formula? or Any other
way to do it?
Thank you for your help!
Jane