Sorry for the newbie question and it probably something simple or was answered before, but i would appreciate any sort of help on this one
I have an excel document with two sheets.
on first sheet i have a table from Column H to S
on the second sheet i have a table from Column E to CU
the answering that i'm looking to get in Sheet1 are located in Sheet2 starting with Column K and then every other 8th column so next one is S then AA and etc.
basically i want in Sheet1
Cell H1 to equal to =Sheet2!K1
Cell I1 to equal to =Sheet2!S1
and so on, but instead of typing it manually i want to be able to drag the formula and every increase in column in Sheet1 will increase the column by 8 in Sheet2.
hopefully the above makes sense and there is a solution to my madness.
Thank you
I have an excel document with two sheets.
on first sheet i have a table from Column H to S
on the second sheet i have a table from Column E to CU
the answering that i'm looking to get in Sheet1 are located in Sheet2 starting with Column K and then every other 8th column so next one is S then AA and etc.
basically i want in Sheet1
Cell H1 to equal to =Sheet2!K1
Cell I1 to equal to =Sheet2!S1
and so on, but instead of typing it manually i want to be able to drag the formula and every increase in column in Sheet1 will increase the column by 8 in Sheet2.
hopefully the above makes sense and there is a solution to my madness.
Thank you