Hi,
I've a problem that I can't find the solution to.
I have multiple data sheets with tables and I want to create a master sheet table that automaticly will update when now rows/data is added in to the sheets in any of the data sheets.
Master sheet will look like this (the first 3 letters is the data sheet name), this is just the first column there a a lot more columns to be added
AAB08
AAB09
AAB10
AAB11
AAB12
AAC08
AAC09
AAC10
AAC11
AAC12
AAD08
AAD09
AAD10
AAD11
AAD12
So when let's say in sheet AAB I add another row AAD13 I want the master sheet to update automaticly so it looks like this
AAB08
AAB09
AAB10
AAB11
AAB12
AAB13
AAC08
AAC09
AAC10
AAC11
AAC12
AAD08
AAD09
AAD10
AAD11
AAD12
Is this possible?
I've a problem that I can't find the solution to.
I have multiple data sheets with tables and I want to create a master sheet table that automaticly will update when now rows/data is added in to the sheets in any of the data sheets.
Master sheet will look like this (the first 3 letters is the data sheet name), this is just the first column there a a lot more columns to be added
AAB08
AAB09
AAB10
AAB11
AAB12
AAC08
AAC09
AAC10
AAC11
AAC12
AAD08
AAD09
AAD10
AAD11
AAD12
So when let's say in sheet AAB I add another row AAD13 I want the master sheet to update automaticly so it looks like this
AAB08
AAB09
AAB10
AAB11
AAB12
AAB13
AAC08
AAC09
AAC10
AAC11
AAC12
AAD08
AAD09
AAD10
AAD11
AAD12
Is this possible?