Combine 2 sheets

[issa.o]

Hi my friends
nothing goes bad, all things are okay.
I have two workbooks, one is called analysis3 and another is grade33.
I need all sheets from workbook grade33 to shift into work book called analysis3 except the sheet named main sheet with its formulars to work.
And i have a challenge i tried to doing it but in sheet named best students it give 0 results i don?t know what is wrong.
I need to find average in r267 and r268 you will see comments of what i wanted also in workbook called analysis
and to correct formula in sheet called grade33 in sheet best 5 and weak students
i need somebody to help me
see the attachment

[sandy666]

are you still on XL2007 ? If not update your profile to the real version you have

[issa.o]

Yes i am still in 2007

[sandy666]

XL2007 doesn't support Power Query also there is many merged cells
maybe someone else will give you formula solution
have a nice day

[issa.o]

Only what i need is to combine sheet in one work book to another those formular and still to doing work or give that output you see anyone help me please i fel headache because of that very tough task i have today

[sandy666]

on GRADE33 are any circular references the same will be on ANALYSIS3 so you need to fix it yourself

cr.png

the formula refers to itself

ccref.png

[issa.o]

Thanks much it works well but i have also another sheet for grade five. And grade five they have 7 subjects while grade three they have 6 subjects.
I need you to help me again to combine two work books agin. But sorry for disturbing you
i have a work book called best and weak7 and another is called grade 6.
I need all sheets in work book of best and weak7 to be in a workbook of grade6
thanks much
see the attachment

[sandy666]

check attachment

[issa.o]

ve output as it was at the beggining
see the attachment

[sandy666]

for future

open these two workbooks and then choose that one from which you want to move sheets

movesheets.png

[issa.o]

Thanks much I learn a new things and for future I Will do many things myself.
But for the above attached file I am tired I tried alot to copy and pest the real data but it doesn't work

[sandy666]

without seeing files I can't say more, sorry