Removing column from calculation

Hello, I've searched for something similar but could not find anything related.
I have a file that has measurement data on the "data" tab. There could be up to 100 measurements for each point.
There is also a "calculation" tab which performs the required calculation but only does so on the last 30 samples. This tab is protected for viewing only.

What I'd like to be able to do is pick one or more columns in the "data" tab and have it disappear from the "calculation" tab and the remaining columns backfill to keep 30 samples. If you then uncheck the column it will reappear in the "calculation" tab.

I've been doing this by actually deleting the column and then hitting "undo" to bring it back but I would like to keep all the data present on the "data" tab.

I have included a file that has similar data to what I'm working with. There is no program on this file though.

Any ideas on how to do something like this?

Rick

barryleajo,

I can see how this works with hiding the columns and working with a coded calculation. I'm not sure I'm explaining correctly. I need to select columns on the data tab to be deleted from a cell formula calculation in another tab.

Say data tab has columns labeled 1 to 10. The calculation tab uses 1 to 5 for the calculation. If I delete column 2 in the data tab I need that to be deleted in the calculation tab and then use 1,3,4,5,6. (so the next available column data is used). When I deselect the column it returns to to the calculation page.

I hope this makes it clearer on what I'm trying to do.

OK rwqiii
I've done a bit of work with your data now.
Try the attached to see if selects the correct data set.
Hide some columns in the Data sheet and run macro called "calcminuscols()".
It will take the first 30 data values that are not in hidden columns into the Calcuation sheet.
Note only data in the first data row (row 7) is used in this example, just to test that this is what you are looking for.
Note that I haven't built-in column select/deselect or error-checking etc.
This may help you complete your requirement.
Happy to work with you further if needs be.

barryleajo,

Thanks for the help. I've tried this out and it looks very close to what I'm looking to do. I must admit I don't know arrays very well at all. How do you get this to move the other rows and still not include the designated columns?

Thanks again Rick

Hi Rick
Check the attached.
I think it does what you require.
The loop is a bit "pedestrian" and I'm sure the 'filling' of the data can be speeded-up.
First things first though - I'm still learning about manipulating arrays too!
Barry

Thanks for the help barryleajo,

This project is going so for me. Sorry for the long response time. I hope I can take a look at this soon and let you know how things work.

Rick

barryleajo,

Thanks for all the help. I got what I needed and was finally able to get things working correctly.

Thanks again,

Rick