MrExcel Publishing
Your One Stop for Excel Tips & Solutions

tough one: filtered list: moving rows up and down


Posted by Paul on January 25, 2001 2:50 PM

I have a worksheet that has a header with autofilter applied.

I am able to programmically move data row up and down with a spin button to position rows for the data sheet.

When, I apply the filter to worksheet data I am unable to move the data due to the gaps in the data.

Example
unfiltered:

Header row: ID field, name, dept
r1 10000, bob, HR
r2 10003, sandy, sales
r3 10005, george, HR

I am able to move r3 to r2 position

Filtered:
r1 10000, bob, HR
r3 10005, george, HR

I am unable to switch these rows.

any suggestions?

-P


Posted by Mark W. on January 25, 2001 3:23 PM

Paul, may I ask why you're shifting rows? Normally,
in a relational list the ordering of rows is irrelevant.

Posted by Paul on January 26, 2001 5:54 AM

Yes, the list is a list of job information, that information needs to be ordered and will be used on another worksheet. The user first filters the machine to work on then he/she will line up the jobs, then other processing will take care of the rest.

The problem is I am not sure the row/cell properties of the rows in between when filtermode is on. Effectively, when filtering is not on I have the user select the job number in column "A", do some checking and do a cut, paste to swap out the rows. I haven't figured how to do it with filtering on though.

-P