Arrange rows based upon a number in text of first cell

[stearno]

I have 211 rows. The first cell in each row has text, then "EURUSD" and then a number. I need a way to automatically arrange the rows, grouping the items by that differentiating number (i.e. all "1's" together, all "5's" together, etc.).

I have attached an example. Sheet1 is the data. Sheet2 shows how I was doing this manually.

Is there a way to do this with VBA?

I thank you in advance for your guidance.

[nankw83]

Hi stearno,

There's no attachment showing. Please check the top yellow banner on how to attach a file

[stearno]

Sorry, its attached now.

[nankw83]

What does "GL_L1_EURUSD1" refer to from Sheet1 ? I can't relate & couldn't figure out how you arrived at 1.17670428571428 in Sheet2 under 2020.08.10 18:22:22

[stearno]

I did a cut and paste. I cut "GL_L1_EURUSD1" from Sheet1 and pasted it into Sheet2. Thats why its not in Sheet1 anymore. But it used to be in one of the blank rows in Sheet1.

[nankw83]

Just to confirm, so any cell in column A of Sheet1 that ends with "EURUSD1" has to be transferred to Sheet2 ?

[stearno]

Just to confirm, so any cell in column A of Sheet1 that ends with "EURUSD1" has to be transferred to Sheet2 ?

Correct, step 1: move EURUSD1 to sheet2. Then step2: move all EURUSD5 under EURUSD1 on sheet2, then step3 move all EURUSD15 under EURUSD5 on sheet2, etc. Until all the data on sheet1 is on sheet2, but arranged in groups.

[nankw83]

Try the below code & let me know if this is what you're looking for

Please Login or Register  to view this content.

[zzzeddy]

Hi

My code is a bit longer, but hopefully does what you ask for.
In the attached file, I make a copy of your Sheet1 - (named the processed sheet as "output") for testing.
For convenience, I added a button and assigned my macro to the button.
Click the button to sort the data into groups.
Having another method doesn't hurt.

zeddy

[stearno]

Thank you guys, that worked! I appreciate the help!

[nankw83]

Glad to help ... If that takes care of your original request, please mark the thread as 'SOLVED' from the Thread Tools menu above the first post & consider adding Reputation by clicking the star icon below their usernames to those who have helped