Help with VBA code to link tables together and specify formulae

Hi Folks,

Attached is the sheet in question, which I am trying to do 3 things on.

1: I am trying to link the tables such that the column names need only be changed in the table at the top (confusingly called [Table 2]). The columns currently called "Channel name", "Channel name2" and "Channel name3" will need to be change-able by a user. I would like the user to just have to change the top column names, and the other tables will update too. This needs to be able to interact with the existing 'Add Channel' and 'Clear table column' macro button functions.

2: In a similar vein to the first problem - is it possible to link 4 of the tables which contain dates in the following way: Presently the document has 5 dates selected and populated with data. Is it possible that only the top table ('Table 2') has to have the dates selected, and the other three tables with date selections be updated to copy the top table automatically? This would save users from having to manually select the dates 4 times, and instead just do it once.

3: 'Table 25' and 'Table 257' presently use formulae to get their data from the inputs in the other tables. The macro to clear the tables obviously gets rid of this data in these tables - but is there a way to keep these tables using the same formulae even when using the macro, and when adding a column using the 'add channel' button? It would be very helpful to keep the formulae for these tables consistent even when clearing/adding columns. But I am not sure if this is possible.

Thanks for any help, please let me know if anything is unclear.

Hi,

Only Table 25 and Table 257 have formulae in - the other tables are for manual user input. For these two tables, I would like to be able to keep the formulae consistent even when using the macros, as well as my other two requests.

Thanks

Fab - thank you!

Hi Apologies I have been away so haven't seen this. I've just had a look at your example and many thanks for it! I just have a few clarifications/questions.

The rows are hidden because they are 0, yes. The user is going to be able to select the dates they have data for and put figures in, leaving the others hidden and not picked up by the table. Is there a way to keep all the dates in as options (like Table 26 remains in your version) - rather than removing them as the other tables have had? I would then like to be able to allow for the user to select the dates they want to enter in the top table, and the other tables with dates update to display these dates also.

Thank you very much for helping automatically update the formulae in tables 25 and 257! I really like the 'remove last table column' too, really helpful and a much more useful method.


Finally - would it be possible to allow for a user to update the column name (from the prepopulated one) in the top table to whatever they want it to be, and then have this update down the other tables? Eg. Changing the title "Channel Name" to "Something else" makes each other table header in that column change to "Something else" too?

Thanks again for all your help on this. I'm going away at the end of this week again so might be slower replying again.

Hope you enjoyed the final - can't stop the king of clay, can you?

I am mostly unfamiliar with pivot tables unfortunately so would be going in fairly blind to that.

The number of columns is variable yes - users will be able to add and remove as many columns as they want. Realistically this is unlikely to ever be more than 12-15, but appreciate this may be an issue?