One Workbook, 6 sheets, 6 identical ranges C2:N553… Sheet 1 is my calculation sheet and C2:N552 is where my data is calculated from… So I want C2:N553 from Sheet 2 to be calculated. Do I, 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… OR, do I use VBA to get the data and if so, why?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

In this scenario could somebody please explain the pros and cons of VBA…

Thread starter How_Do_I
Start date Jul 20, 2010

How_Do_I

Well-known Member

Jul 20, 2010

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?