Ok i am guessing that this will be a VBA problem cause I can not think of how else it will be done.
I want to create about 8 tables in different worksheets. (simple enough, copy and paste) however here is the catch, What I want it do do to one I want to do to all, so If I add a column and header on sheet 1, it will duplicate it on sheet 2,3,4,5,6 etc.
I ONLY WANT the table to duplicate NOT THE DATA! so for example on sheet 1 i might have 6 collums with XXXXXXXXXX data entered. I want 6 columns to appear on sheet 2 which contains YYYYYYYYYYY data, and 6 columns on sheet 3 with ZZZZZZZZZZZZZ data entered, then If i enter a new column on sheet 1, it adds a new blank column (With the same header from sheet 1) on sheet 2,3,4,5,6,7.....
Can some one help me out with this please.
Bookmarks