开发者

How to Sort Data in Excel file using VBA

i am trying to Copy data from all Sheets to one sheet and Sor开发者_开发技巧t it Alphabetically.

My excel file contains CD names and Tracks, when i am sorting this data i m able to sort by CD Names but only first track of CD comes. rest of tracks are ignored.

please help me out for this.

Thanks in Advance....


Can't you use the sort method of vba?

Besides, you can record a macro to create some code and adapt it to build a fully functional procedure.


Does your data look like this?

A    B
CD1  Track1
     Track2
     Track3
CD2  Track1
     Track2
     Track3

If so, you need to fill in the blanks in column A. Select A2:A??? (as far down as your track data goes). Press F5 (Edit Goto), click Special Cells, Blanks. This will select all the blank cells in column A for your data.

Next, in A2, type =A1 and enter using Control+Enter. This will enter that formula in all the blank cells. Control+Enter enters an array formula. It's a way to enter a single formula in a bunch of cells at once. Your data should now look like

A    B
CD1  Track1
CD1  Track2
CD1  Track3
CD2  Track1
CD2  Track2
CD2  Track3

Now select A1:A???. Edit - Copy. Edit- Paste Special - Values (don't change the selection - paste right over the existing data). Now if you sort on column A, all your CD1 tracks will be together.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜