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
