+ Reply to Thread
Results 1 to 2 of 2

I got my excel table disorganized accidentaly PLZ SOS

  1. #1
    Registered User
    Join Date
    03-29-2017
    Location
    Hungary
    MS-Off Ver
    2007
    Posts
    1

    Unhappy I got my excel table disorganized accidentaly PLZ SOS

    At my workplace... I'm new there :S

    There was a certain table, filled from jan 1. weekly with very very many lines

    1st column was names, 2-3 some was section codes, the others was weeks (spli scleen vertically somehow can slide weeks horizontally)

    Team leaders rows was fixed i think, subsections was not (didnt see the exact problem yet ,my collegue just called and was pisssed ofc)

    Name Section Section X Screen split Week1 Week2 W3......
    -teamleader......code..........code...............................01.05.....01.8....0
    .worker
    .worker
    .worker
    -teamleader


    And i arranged the names column by name, and the whole got messed up. It mixed the fixed teamleaders row between subsections, and the date columns did not came after ect.

    I saved the document ofc. So there is no ctrl+z.

    Is there a way to undo this? Or any kind of method to rearrange properly, if i have a data on written documents? Not manual, bat some kind of (=gagfasgasg;gsagasgas) function?

    As u see im not a genius so a blank function form maybe what i can use? IF xy name had A B C D E dates Ect Dont know PANICC!!!
    Last edited by Divisor; 03-29-2017 at 06:16 AM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: I got my excel table disorganized accidentaly PLZ SOS

    This might help: https://support.office.com/en-us/art...ad=US&fromAR=1.

    It may be too late to save this situation, but there are a number of backup utilities out there, many of them are free. The are a couple of sayings in the IT world:
    "You don't have to back up all your data; only those that you want to keep."
    "There are two kinds of data analysts: those who have lost data and those who will."

    Good Luck.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Copying Excel table range to an existing PPT slide, pasting as TABLE, not as PICTURE
    By gurnblanston27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2016, 04:44 PM
  2. Hardcopy list generated by Excel's Data Table, refresh table and repeat
    By Ronnet2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-27-2015, 06:24 AM
  3. INDEX(MATCH()) between Excel Table and Duplicate of Excel Table
    By ExcelBin in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-28-2015, 05:16 AM
  4. Replies: 0
    Last Post: 11-06-2014, 07:25 PM
  5. Replies: 0
    Last Post: 09-10-2012, 09:19 AM
  6. Replies: 2
    Last Post: 08-19-2012, 06:29 PM
  7. How to keep user from accidentaly deleting default-value formulas?
    By matkiros in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2012, 05:06 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