auto sort range of cells when one specific cell changes

March 18, 2013 at 07:20:39
Specs: Windows 7
i have various blocks of data on one ws, the data is infilled from another ws.what i require is to auto sort that block of data, column '18','9','6','3','2','1', as cell E33 changes,( this is a countif command for this cell). Secondly to this i then need to be able to move to the next block of data, and auto sort that block subject to cell ?33 changing. Information only updates subject to corresponding date entry........please help, very new to the macro/vba side of things and not really sure what i am doing

See More: auto sort range of cells when one specific cell changes

Report •


#1
March 18, 2013 at 10:00:56
I'm not sure what you mean by "what i require is to auto sort that block of data, column '18','9','6','3','2','1',"

In Excel, columns are usually designated by letters, rows are usually designated by numbers.

"i then need to be able to move to the next block of data..."

What block of data?

I think you need to post an example of the data in your workbook and the desired result based on that data. Please click on the following line and read the instructions found via that link before posting your data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 18, 2013 at 11:39:05
Hi there,
Havent really explained things that well.
Is there any way i can email you the workbook, (single sheet)
From that you should get a better understanding of what I'm trying to achieve
I have recorded a macro to 'sort' the data as required, but need to then move to the next group/block of cells to then sort those.Each group or block only has data entered on specific days
I also believe that if a cell changes value, the macro can run automatically, how do I do this.
I am a complete novice at the macro / vba side of things so be kind.
A look at the worksheet will help you see what i am trying to achieve

Thanks
Tony


Report •
Related Solutions


Ask Question