+ Reply to Thread
Results 1 to 4 of 4

Possible to shift columns across multiple tables in different sheets?

  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
    477

    Possible to shift columns across multiple tables in different sheets?

    gosh I hope so! what would one do with various sheets with the same tables that need their columns rearranged? I don't think you can do this but I don't know for or if there is some kind of solution. When I try to do this I get an error message. seems simple enough to take two columns and switch their positions/data across many sheets that happen to be in a table.
    Excel 1.0.1 (16.0.14326.20140) (Android)
    Excel 2010 14.04.4760.1000

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,479

    Re: Possible to shift columns across multiple tables in different sheets?

    Hopefully this will get you started ?
    Attached Files Attached Files

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,053

    Re: Possible to shift columns across multiple tables in different sheets?

    This way takes a few steps, but it works.

    1. Click on the 1st tab you want
    2. hold the SHIFT key and click on the last tab
    You should see that they are now all "grouped", and whatever you do to 1 sheet, gets done to all sheets
    3. Highlight the 1st column you want to move, and drag it off to the side
    4. move the 2nd column to where the empty column is now
    5. move the 1st column to where you need it
    6. Click on any ungrouped cell, or rt click and select UNgroup

    DONT forget to do that last step, or you could mess up some sheets by editing 1 sheet and having that edit carry though to all the other sheets
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

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

    Re: Possible to shift columns across multiple tables in different sheets?

    Thanks guys/gals. I'll try these next time. Already went a long route doing them all individually but I'll be doing it again in time as I often need to edit things.

+ 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: 1
    Last Post: 08-23-2016, 02:44 PM
  2. Replies: 2
    Last Post: 06-24-2016, 01:26 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. Replies: 6
    Last Post: 03-12-2014, 09:23 AM
  5. Pivot Tables - need to do separate pivot tables for multiple sheets in same format
    By tconnell1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 07:04 AM
  6. DATA TABLES and multiple sheets
    By kayard in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 06:05 PM

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