Excel question

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • mkx
    Confirmed User
    • Nov 2003
    • 4001
    #1

    Excel question

    Ok here's the situation. I have one sheet with line by line unique items example:

    Item Lala Lala2 Lala3
    304 Spec Spec Spec
    305 Spec Spec Spec
    308 Spec Spec Spec
    etc

    then I have another sheet with repeat items example:

    304
    304
    304
    304
    304
    304
    305
    305
    308
    308
    308
    308

    etc.

    Is there a quick way of auto filling specs to the multiple item lines based on the information I have on the single item/line sheet? I reckon it will take me a couple hours to do this manually.
    Tags: None
    • mkx
      Confirmed User
      • Nov 2003
      • 4001
      #2
      $5 paypal to anyone who can explain this to me so I can get it done

        Comment

        • mkx
          Confirmed User
          • Nov 2003
          • 4001
          #3
          Basically I need to tell it this but I don't know the language

          If Z(Sheet1) = A(sheet2), copy and paste B D E and F from Sheet2 to AA AB AC AD and AE on Sheet 1

            Comment

            • mkx
              Confirmed User
              • Nov 2003
              • 4001
              #4
              $10 paypal

                Comment

                • After Shock Media
                  It's coming look busy
                  • Mar 2001
                  • 35299
                  #5
                  Originally posted by mkx
                  $10 paypal
                  That is like 10 days worth of labor in parts of Bangladesh. To bad they do not have computers though.

                  [email protected] ICQ:135982156 AIM: Aftershockmed1a MSN: [email protected]

                    Comment

                    • marketsmart
                      HOMICIDAL TROLL KILLER
                      • Dec 2004
                      • 20419
                      #6
                      bump to help you!

                        Comment

                        • shekinah
                          Confirmed User
                          • May 2006
                          • 8452
                          #7
                          Maybe you highlighted it and you drag it all down that's why it's repeated.

                          [Web Design | Development | Programming | Content Writing ]
                          ICQ: 238-890-469

                            Comment

                            • E$_manager
                              Too lazy to set a custom title
                              • Apr 2006
                              • 13557
                              #8
                              You had a nice chat with yourself
                              Enjoy more sales with EnjoyBucks!
                              Homemade: Asian : Ebony : GFs : Voyeur : Nudist : Public : 3D

                                Comment

                                • mkx
                                  Confirmed User
                                  • Nov 2003
                                  • 4001
                                  #9
                                  30 more minutes and ill be done

                                    Comment

                                    • mkx
                                      Confirmed User
                                      • Nov 2003
                                      • 4001
                                      #10
                                      And done

                                        Comment

                                        • psili
                                          Confirmed User
                                          • Apr 2003
                                          • 5526
                                          #11
                                          Did you get the VLookup working, or am I off in what you were trying?
                                          Your post count means nothing.

                                            Comment

                                            • mkx
                                              Confirmed User
                                              • Nov 2003
                                              • 4001
                                              #12
                                              I did it manually

                                                Comment

                                                • DjSap
                                                  Confirmed User
                                                  • Jul 2002
                                                  • 3869
                                                  #13
                                                  vlookup would be what you were looking for...remember it for next time...
                                                  Blog Themes, TGP Design, Writing Services, Grunt Work
                                                  ICQ: 66871495

                                                    Comment

                                                    • Mad man
                                                      Confirmed User
                                                      • Sep 2006
                                                      • 109
                                                      #14
                                                      I hate that program. I seem to move stuff around and run into trouble like you did. I usually look up some info on google. I wouldn't think to ask on gfy.
                                                      http://www.maddiestyle.com Contact Me (link trades) - maddmail/at/maddiestyle.com
                                                      Starter webhosting - use dreamhost (Sign up here) Right now I’m recommending (moneytree live cams Sign up here)

                                                        Comment

                                                        Previous template Next
                                                        Working...