• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to flip a data set [SOLVED]

Why not?
If You have one column for 'flip'.
Your data is sorted with that 'flip'
You'll sort Your data opposite way.
Or
What kind of data do You have.
 
I don't believe the sort feature has an option to flip. It looks for parameters, like sorty by alaphabet, etc. .. This data set is all in column one, but no logic in terms of a criterion the sort feature could use. I do not want it sorted so much as flipped upside down. Different number of rows in every data set, so it would dynamically find the last row and then proceed to flip the entire data set upside down.
 
This data set is all in column one ...
and You cannot add another column for 'flip'?
Before 'Flip' You fill that column as row numbers 2... y_max
and
after that You can sort Your data with it opposite ... cannot You?
If no need that 'flip'-column later, that can always delete.
 
Ok, i see what you are saying .. populate another column with 1, 2, 3, 4, etc ... then sort by that column. But the macro that populates the new column would have to know how many rows are in the data set.
 
... You have that data ... in column-A.
You can find that number of rows 'easy' way
or
just make loop which adds numbers from 2 until nothing in Column-A cell...
Do You have any sample data?
Or should someone do it?
 
I grabbed the code, went into my personal workbook and put it into a module I name FLIP. Saved personal workbook. Closed Excel. Opened Excel. Went into macros. It isn't there in the list of macros, but is still there in the modules when you open the editor window. Why is it not showing up in the macros list like all my other macros?
 
You must log in or register to reply here.
Back
Top