Sheet to Sheet copying

[sachinahj]

Hi I have the current code...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Everything under the worksheet_activate sub works fine but the code under worksheet_calculate doesn't execute. Any suggestions??

[patel45]

what's your goal ? explain us

[sachinahj]

Ok.

There is a summary sheet and then a possible amount of up to 35 more sheets after that. This macro is for the summary sheet. On sheet activate the first macro fills C1:AB1 up with the names of the worksheets.

On these other sheets i have names from A2:A39. And there totals for that sheet from B2:B39. The names are on every sheet along with the summary sheet but are in the same order so that keeps it easier.

I am trying to copy the other sheets B2:B39 and paste it into the summary sheet starting from C2:C39 for the first sheet and then D2:D39 for the second sheet and so on. And I want to the summary sheet to grab these totals when I calculate the sheet using F9 for Windows and cmd + = for Mac.

If you have anymore questions, don't hesitate to ask. I hope you can help me out. Thanks

[sachinahj]

ok im pretty sure the following code should work

Please Login or Register  to view this content.

But i get a "select" on the "range" fail for the line "Range("B2:B39").Select".

Any tips?