How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
One Workbook, 6 sheets, 6 identical ranges C2:N553…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
Sheet 1 is my calculation sheet and C2:N552 is where my data is calculated from…
<o
></o
>
So I want C2:N553 from Sheet 2 to be calculated.
<o
></o
>
Do I,
<o
></o
>
Use =CHOOSE(A1,Sheet2C2:N553,Sheet3C2:N553…etc…) using the correct syntax of course and placing the formula snugly in C2, copying across and down…
<o
></o
>
OR, do I use VBA to get the data and if so, why?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
Sheet 1 is my calculation sheet and C2:N552 is where my data is calculated from…
<o
So I want C2:N553 from Sheet 2 to be calculated.
<o
Do I,
<o
Use =CHOOSE(A1,Sheet2C2:N553,Sheet3C2:N553…etc…) using the correct syntax of course and placing the formula snugly in C2, copying across and down…
<o
OR, do I use VBA to get the data and if so, why?