Dumb question I know...

**kuja** · 11-09-2010, 04:05 PM

I realize this is likely a dumb question but for the life of me I cannot seem to find the answer.....
I am trying to take Column A and paste it into column B but with one catch I need to reverse the numbers. Meaning I need line 100 to be line 1 and line 99 to be line 2. Of course when I do in line b1 =a100 that is nice however when I copy and paste that into line b2 it is 101 and I want it to be 99.
this is just an example in reality i have over 1000 lines to move and dont really wanna do it manually ....

Any ideas? Seems there should be a way to accomplish this...

thank you in advance for any help !

**TMS** · 11-09-2010, 04:18 PM

In cell B1:

Please Login or Register  to view this content.

and copy down

Regards

**kuja** · 11-09-2010, 04:43 PM

Thanks! this has totally done the trick, thank you so very much for your help!

Originally Posted by TMShucks

In cell B1:

Please Login or Register  to view this content.

and copy down

Regards

**TMS** · 11-09-2010, 05:48 PM

You're welcome. Thanks for the feedback.

**NBVC** · 11-09-2010, 05:57 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST