+ Reply to Thread
Results 1 to 4 of 4

Sort/Copy/Delete the same cells on multiple sheets, with table.

  1. #1
    Registered User
    Join Date
    12-15-2017
    Location
    Mainland Europe
    MS-Off Ver
    2010
    Posts
    2

    Sort/Copy/Delete the same cells on multiple sheets, with table.

    Hello y'all,

    Not sure if this is the correct subforum, as a macro may be more useful for what I want.

    Within an Excel file I want changes on sheet(1) which contains a table, to affect other sheets. Any moving, copying, deleting or sorting of different rows, columns and ranges should be reproduced on other sheets.
    So, if I would cut/paste P5:T15 to T5:X15 on sheet(1), the same cut/paste action should happen on sheet(2) and sheet(3).
    Also if I would sort the table on sheet(1), the data in the other sheets should be moved in the same pattern, as the data on a given cell on one sheet is related to the same cell on another sheet.

    The solution to select multiple sheets in excel results in the error: "Cannot make changes to a table or XML mapping when multiple sheets are selected."
    The table on sheet(1) is causing this method not to work. Ideally I'd keep the table as it makes sorting through the data manually easier. So I'm looking for an alternative method. Preferably one that makes it so that I can just edit about on the first sheet as I would normally do, without any extra actions that I need to perform, for the amount of data I need to edit is already quiet a handful.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,437

    Re: Sort/Copy/Delete the same cells on multiple sheets, with table.

    Please edit the location in your profile. You don't need to by particularly specific: just indicate whereabouts you are, as this impacts on solutions offered (e.g. US, UK, Europe, etc.).
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    12-15-2017
    Location
    Mainland Europe
    MS-Off Ver
    2010
    Posts
    2

    Re: Sort/Copy/Delete the same cells on multiple sheets, with table.

    Ah, makes sense. Generally speaking I don't like giving much personal info on the interwebs, but here it actually serves a pulpous. Thou sometimes I wonder why we can't just have a decent standard for decimal and thousand separators etc., but that's a different topic altogether.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,437

    Re: Sort/Copy/Delete the same cells on multiple sheets, with table.

    Thanks for complying.

+ 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: 0
    Last Post: 09-06-2017, 08:30 PM
  2. Faster Way to Sort and Copy to Multiple Sheets
    By Lephantome92 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2017, 07:43 AM
  3. How to delete table rows in multiple sheets?
    By erthmill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2016, 12:30 PM
  4. [SOLVED] Need help for a macro to delete cells on multiple sheets
    By Dj Duck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2016, 02:42 PM
  5. Sort and copy data from custom formatted tables on multiple sheets to one area
    By christmaslyric in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2014, 03:14 PM
  6. Replies: 1
    Last Post: 08-21-2012, 03:14 PM
  7. Excel 2007 : Sort multiple sheets, specific cells
    By Assistant in forum Excel General
    Replies: 5
    Last Post: 07-03-2012, 04:04 AM

Tags for this Thread

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