+ Reply to Thread
Results 1 to 2 of 2

How to add columns to multiple sheets with multiple tables over top each other simultaneou

  1. #1
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    How to add columns to multiple sheets with multiple tables over top each other simultaneou

    I'm finding that I can't do this with both multiple sheets with two or more identical tables directly in line vertically of each other let alone with just a single sheet nor multiple sheets with only one table. I'm guessing this is just not possible. Hoping someone can inform me otherwise, otherwise simply adding another column to these tables I have is tedious as I have to do it one sheet at a time and within each sheet with two or more tables I have to first remove the tables(convert to range), then add the column(s) I want to add. Any good news? Thanks guys/gals
    Excel 1.0.1 (16.0.14326.20140) (Android)
    Excel 2010 14.04.4760.1000

  2. #2
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    Re: How to add columns to multiple sheets with multiple tables over top each other simulta

    hmm, "Cannot make changes to table or xml mapping when multiple sheets are selected". sounds like no uh? what's "xml mapping"?

+ 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. [SOLVED] SUMPRODUCT of multiple columns with multiple criteria over multiple sheets
    By BellyGas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2015, 08:27 AM
  2. [SOLVED] Extracting data from multiple columns on multiple sheets / tabs etc to a common matrix
    By MagicMan in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-26-2015, 07:38 AM
  3. Copy Paste multiple tables from multiple sheets into Outlook email
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2015, 12:21 PM
  4. Macro to filter multiple columns of data to multiple work sheets
    By LISSANN in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2014, 07:24 PM
  5. Average of Multiple Columns from multiple Pivot Tables
    By element32d in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-01-2013, 11:08 AM
  6. [SOLVED] align or combine multiple columns from multiple sheets into one sheet in sequence
    By calif in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2013, 11:49 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