Auto sort list into table

[rongil20]

Hi,

I am trying to sort the data on sheet1 into the table on sheet2 based off the currency and time ideally with a macro by pressing a button.

Has anyone got any ideas?

Thanks

testC.xlsx

[jaslake]

Hi rongil20

Try this Code in the attached.

Please Login or Register  to view this content.

[MickG]

Try this:-
NB:- this code will also find Duplicate "CCY/Time" Values

Please Login or Register  to view this content.

Regards Mick

[rongil20]

Hi rongil20

Try this Code in the attached.

Please Login or Register  to view this content.

Thanks, that's really good however I didn't mention that I also need it to place in a new line for the same CCY and time.

For example, if there are 2 USDs, both 1 month and 1 is 10,000,000 and other is 5,000,000. I need them both in the USD - 1m area


Mick - your code gives me a runtime error at the line 'ray(c, 1) = k'

[rongil20]

Ignore the above, I have added a couple of If statements and made it work.

Thanks for the help