I need some OpenOffice/Excel help...

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


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

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.

marusia said:

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.

Click to expand...

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.