Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Adding data from a previous cell

  1. #1
    New Member rlarson's Avatar
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have been struggling with this one for a while. I have an inventory file that I get from a supplier every day, which lists the following data: Part Number; Serial Number. The only problem is that the PN data is listed only once, at the heading for each new Part Number section. Like this:

    Part Number Serial Number
    9014457 ABC123
    ABC234
    ABC345
    ABC456
    ABC567

    9101121 ABC678
    ABC789 ETC...

    The file is usually 2 to 3,000 rows long, with over 200 part numbers. I am looking for a way to add the part number data next to each serial number on the list, basically filling in the Part Number data next to the Serial Number from the header for each section. Do you know of any way to do this other than manually copying and pasting?

    Thanks,
    Randy

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,584
    Post Thanks / Like
    Mentioned
    30 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-02-26 13:38, rlarson wrote:
    I have been struggling with this one for a while. I have an inventory file that I get from a supplier every day, which lists the following data: Part Number; Serial Number. The only problem is that the PN data is listed only once, at the heading for each new Part Number section. Like this:

    Part Number Serial Number
    9014457 ABC123
    ABC234
    ABC345
    ABC456
    ABC567

    9101121 ABC678
    ABC789 ETC...

    The file is usually 2 to 3,000 rows long, with over 200 part numbers. I am looking for a way to add the part number data next to each serial number on the list, basically filling in the Part Number data next to the Serial Number from the header for each section. Do you know of any way to do this other than manually copying and pasting?

    Thanks,
    Randy
    Lets say that the data start in row 1 including labels: Part numbers in A and serial numbers in B.

    In C2 enter: =IF(ISNUMBER(A2),A2,C1)

    and give a double click on the little black square in the right lower corner of C2. Then do a copy while C-cells are selected and execute Edit|Paste Special >Values. Delete column A if so desired.

    Hope this is what you wanted to do.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If it's what I think it is like then you can use an IF statement. If it lists the part numbers and then the serial numbers, but the first column is blank because they all relate to the same part no. ie:
    COL.a COL.b
    12345 333
    444
    555
    666

    In cell C2 use:
    =IF(A2="";C1;A2)

    This will then fill in the blanks, but still put the right data in.

    If this isn't quite what you were meaning, sorry, and we'll have to try again !!!

  4. #4
    New Member rlarson's Avatar
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Helen and Aladin, it worked great!

    COL.a____COL.b
    12345____333
    _________444
    _________555

    I used Helen's suggestion in Col C:
    =IF(A4="",C3,A4)

    Filled in the right numbers next to each SN!

    Much appreciated,
    Randy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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