+ Reply to Thread
Results 1 to 2 of 2

VBA problem? how 2 multiple tables in different sheets so headings duplicate, columns adde

  1. #1
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242

    VBA problem? how 2 multiple tables in different sheets so headings duplicate, columns adde

    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.
    Attached Files Attached Files
    Last edited by born2dive00; 11-27-2019 at 09:18 AM.

  2. #2
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242

    Re: VBA problem? how 2 multiple tables in different sheets so headings duplicate, columns

    I forgot to say that the tables are sort tables, (i.e. have filters)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 21
    Last Post: 07-15-2018, 09:24 AM
  2. Possible to shift columns across multiple tables in different sheets?
    By juntjoo in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-09-2016, 03:21 PM
  3. Replies: 1
    Last Post: 08-23-2016, 02:44 PM
  4. Sumif for inconsistent column headings across multiple sheets
    By sawhorse in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2015, 11:02 PM
  5. Excel Rookie - Duplicate Columns and rows with headings
    By cameleon212 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2014, 03:10 AM
  6. List box with multiple columns and headings
    By Khaos176 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2009, 04:31 PM
  7. Multiple excel sheets with same headings
    By mohitmahajan in forum Excel General
    Replies: 0
    Last Post: 09-23-2005, 02:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1