+ Reply to Thread
Results 1 to 4 of 4

Excel Rows Keep Switching

  1. #1
    Registered User
    Join Date
    06-22-2017
    Location
    USA
    MS-Off Ver
    2013
    Posts
    7

    Excel Rows Keep Switching

    I have two workbooks connected but I switch the way the first is sorted it moves around all of my rows so that the data no longer matches up. How do I prevent this from occurring?

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Excel Rows Keep Switching

    Could you attach your sheets so we can have a look at your problem?
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Registered User
    Join Date
    06-22-2017
    Location
    USA
    MS-Off Ver
    2013
    Posts
    7

    Re: Excel Rows Keep Switching

    The files are too large. I will insert images that will hopefully help. sheet1.PNG sheet2.PNG

    The first sheet is the one the data is coming from. When I sort the any of the date scheduled it changes the two other tabs on the sheet2 attachment.

  4. #4
    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
    52,917

    Re: Excel Rows Keep Switching

    Images are of little help with this kind of problem. We dont need your whole file anyway, just a small sample that shows what you have, and what is happening
    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

+ 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. Avoid Switching Sheets, Reference Sheet Without Switching Instead.
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2017, 06:59 PM
  2. Excel 2007 : Switching Fields / Columns to Rows
    By Potrain in forum Excel General
    Replies: 6
    Last Post: 06-06-2010, 06:18 AM
  3. Switching columns to rows
    By Paige in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2007, 05:38 PM
  4. Switching rows and columns
    By fairmeadow in forum Excel General
    Replies: 1
    Last Post: 04-18-2006, 06:25 AM
  5. switching rows & collumns
    By littlewaywelt in forum Excel General
    Replies: 1
    Last Post: 12-02-2005, 12:50 PM
  6. [SOLVED] Switching rows and columns
    By Brurobiney in forum Excel General
    Replies: 3
    Last Post: 09-08-2005, 12:05 AM
  7. Switching rows and columns??
    By Jarlath in forum Excel General
    Replies: 0
    Last Post: 02-04-2005, 07:21 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