Some spreadsheet help

#1

I have a spreadsheet, and I want to flip the order of a sheet...

For example, the sheet looks like this:

5
4
3
2
1

and I want to make it so that 1, and the adjacent columns simply go to the top of the sheet, and 2 follows right behind it and so on and so on...Any suggestions..?

#2

use tools, sort.

#3

I tried that, maybe I am doing something wrong, have a hack at it... /:D" style="vertical-align:middle" emoid=":D" border="0" alt=":D" />

http://www.ayhja.us/downloads/SetListing.rar

Bot · #4

The closests I could get it is sorting it by release date. That's kind of retarded how it goes 1, 100, 101, 102, 103 etc...

#5

ah. we could have discussed for hours if you would not have shared the book.

problem is that you should not really store text and numbers in Excel

i split them. you can sort now. /wink.gif" style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" />

#6

raum is going to be pissed I had an excel question and he didn't get to write a discourse on it...Hahaha...Thanks Brains...

#7

He'll be pleased to know tho, that the release date column was f0xx0red in the process....

But not your fault, I think the dates got screwed when I saved off the Open Office format I was using...

#8

nononono!!!! i wouldn't do such a thing. they are just in Excel's number format. select the column, right click, format cells, pick "date" and you're set.

but yesyesyes. it could have well got something to do with the openoffice thing.

ah raum is good at excel as well. great. some thing we have in common - in stark contrast to our political views.

#9

I made a new format, that has limited data validation, and identified some errors.

I did a integrity analysis of your index, and noticed Set 70, 72, 169, 172 and 175 were not in serial order. other than that, this will fit your need, and is a much better model for your data, which can sort by year, day, month, index number, and even which sets have names.

So, let me know if you want it.

and yes, Brains, I LOVE EXCEL. and need to learn more vba. I use excel at least 6 hours a day.

#10

FREAK..! lol
Oh, raum, how many Excel sheets you got with VBS..? I need them to test OpenOffice.org's VBA interpreter.. lol (or, if you want to.. lol)