Results 1 to 6 of 6
  1. #1
    khanada
    Guest

    Copying Info from one worksheet to another (Excel 97)

    I currently have a worksheet with data sorted by date. Each row contains cells from five columns that shows office location and whether certains aspects of the project have been completed. I need another worksheet sorted by office location with the same data. When I mark a project completed on the first worksheet, I need it to show that it's completed on the second worksheet. How do I do this?

    Thanks so much for your help!

    -Khanada

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Copying Info from one worksheet to another (Excel 97)

    What method are you using to mark your project as complete ?. That information would be required before it could be adapted/used for the second sheet .

    Andrew C

  3. #3
    khanada
    Guest

    Re: Copying Info from one worksheet to another (Excel 97)

    I'm just marking an "X" in the appropriate column.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Copying Info from one worksheet to another (Excel 97)

    Lets say you name your data on sheet one as Database, and the name of the project is in the first column (A) and the complete indicator goes in the last column, e.g Column J (10th Column). in column J of the second sheet you could insert a lookup to sheet 1 to pick up the value of the indicator. For example in J2 on sheet 2 you could enter VLOOKUP(A2,Database,10,False), which should return the status of the project named in A2.

    If you have a difficulty with the above, please attach a sample worksheet with some dummy data so that we can provide a solution.

    Andrew C

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying Info from one worksheet to another (Excel 97)

    Go to the second sheet and select the cell where you want the top left corner of the table to appear on that sheet. In that cell, put a reference to the top left cell of the table on the first sheet, it should look something like this: =Sheet1!A1

    Now, fill this formula down the column for the number of rows in the table. Now select these cells and fill them right for the number of columns. Format any of the cells that need formatting (like the dates). You should now be able to sort this table into any order you want, and any changes to the original should show up in the new table.
    Legare Coleman

  6. #6
    khanada
    Guest

    Re: Copying Info from one worksheet to another (Excel 97)

    Thanks guys! You're absolute lifesavers!!!

    -Khanada

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •