Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filling rows from previous row (Excel 97)

    I have a spreadsheet that was imported from another computer software. It contains information regarding payments. A person could have several rows of data. Currently, the spreadsheet will list the person's personal info (name, SS) with one amount and the other amounts on a row by themselves. This is a large spreadsheet and I would like to know if there is a function to look for blank cells and take the data from the top cell and copy and paste it in the next cells so all the personal info is attached to every amount.

    One person could have multiple lines or one line. They are running adjacent and the only gaps can be filled with the personal info from the record above.

    please help!

    Deborah

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filling rows from previous row (Excel 97)

    Check out the tip in <post#=364913>post 364913</post#> (or to cut out 1 extra click of the mouse, direct link to the relevant site)

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filling rows from previous row (Excel 97)

    THANK YOU!

    This is such a wonderful feature and I appreciate the rapid reponse.

    Deborah

Posting Permissions

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