Need help in writing a Macro to sort the columns in the worksheet

**shanvin** · 03-21-2013, 10:59 AM

Hi

I have two sheets in my workbook...Let say Sheet2 and Sheet3

I am trying to copy the data from a workbook and pasting the data in sheet2 and sheet3

I have a Macro Button for sheet2 if click the button it has to sort the columns in ascending order....and doesent want to give any range because the count of columns will be increasing so ia want a code to be dynamic.

Please advise

**krjoshi** · 03-21-2013, 11:03 AM

Hi Shanvin,

Which column you want to sort in ascending order first. Could you please attach the sample file, so that look at it.

Cheers,
Joshi

**shanvin** · 03-21-2013, 11:09 AM

Hi Joshi,

As i said Before I have two sheets where in both the sheets the data will be the same

where while extract the sheet sometime data will be not sorted in any of one sheet so what we used to do is we will sort all the columns in both the sheets to ascending order and then try to compare the sheets

Regards
Vinoth

**krjoshi** · 03-21-2013, 01:46 PM

Hi Vinoth,

Try the attached file.

If you're satisfied by any members response please use the star icon at the lower left of their post.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you have issues with Code I've provided, I appreciate your feedback.

**shanvin** · 03-22-2013, 02:21 AM

Thanks Joshi Macro worked

**shanvin** · 03-22-2013, 06:24 AM

Hi Joshi,

I was using the Below Macro to Compare the data in Sheet1 and Sheet2 of a work book

Please Login or Register  to view this content.

But If the data is Huge let say more than 1 Lakh then macro keeps on Running.
Can You Help me in this?

And also You can advise me on the below

Right now we have two systems where we are extracting the data in excel sheet
So we have two Excel sheet and both contains the same data but data is huge let say it can cross over 5 lakhs .So advise me what will be the best approach to compare both sheets?

Regards
Shanvin