1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

I need some OpenOffice/Excel help...

Discussion in 'BlackHat Lounge' started by nothingmore, Apr 12, 2012.

  1. nothingmore

    nothingmore Junior Member

    Joined:
    May 1, 2011
    Messages:
    190
    Likes Received:
    219
    Location:
    The Lounge
    I'm wanting to automate how I make .txt files for scrapebox blasts. This would be for trackbacks.

    My question is how can I make it so I can get B1 to A2, B2 to A5, and so on... Column A has keywords spaced out and column B will have URLs. I'm dealing with around 4000 links so I was thinking theres got to be an easy way to just paste the links spaced out somehow. Then once they are all in column A I can just copy and paste to a .txt file.

    I have an idea right now where I but in =B1 in A2 but how can I make it so I could highlight A1-A3 and drag it
    [​IMG]

    Edit: Here may be a better explanation:

    in A2 I have =b1, when I highlight A1-A3 and drag down it makes A5 =b4, but I want it to be =b2

    [​IMG]
     
    Last edited: Apr 13, 2012
  2. marusia

    marusia Senior Member

    Joined:
    Oct 25, 2010
    Messages:
    1,122
    Likes Received:
    2,320
    Before I go into further detail, can you clarify if this is what you are looking for?


    View attachment 10334

    If so, then in your cell that needs the linking, put =$Sheet1.$B$1 and continue altering the last digit to reflect on the cell you want to reference. If that's not what you're trying to do, let me know and I'll help more.
     
    • Thanks Thanks x 1
  3. nothingmore

    nothingmore Junior Member

    Joined:
    May 1, 2011
    Messages:
    190
    Likes Received:
    219
    Location:
    The Lounge
    Hi thank you for responding.

    Yes that is what I am wanting. You say to alter the last digit for each one but the thing is, I have 4000+ URLs. Is there a way I can do a "drag" or a more automated way rather than replacing the number at the end 4000+ times? Thank you for responding.