How to copy data from one worksheet to another

[Closed]
Report
-
Hello,

I'm having the following problem,
I have made a file with two active worksheets.
Now I would like to copy the totals from worksheet1 into worksheet 2 automatically : normally I do this with sheet1!(cell position).. However , as on the first sheet there are hidden colums ( three per column on sheet2) excel Always takes the values from the hidden colums (sheet 1 as well). So only every fourth column on sheet 2 is correct.. How would I have to make the formula to only get the 1st,4th,8th total into sheet2?


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!