I have a range that I use with an autofilter of 30 people for each day of the
week, each labeled in Column A as 1,2,3...30, etc., with the same number for
each person for each day. The same person would be on a row labeled 1 for M,
T, W, etc., the next person 2 for M, T, W, etc., etc.
I have a macro that shows only the ACTIVE people, so the user may only use
the first 6 people, for each day of the week.
Their information is also tied to a specific sheet in another workbook with
their weekly data. When a person leaves, I want to move this person from
their slot into a non-used slot (like 29, 28, 27, etc), along with their
corresponding data in the other worksheet. Moving the data in the seperate
worksheet is not an issue. I've created the program to set the number of
visible positions to 30, but I can't figure out in any SHORT way to move the
person say in slot 3 to slot 29, for all seven days of the week. The person
in slot 3, would have seven cells of data that need to be moved to seven
cells of data labled slot 29, one cell for each day of the week. Hope this
isn't confusing! I would appreaciate any help to get this wrapped up!

David

The table looks like this:
Monday
1 David
2 Tom
3 Harry
4 Blank

Tuesday
1 David
2 Tom
3 Harry
4 Blank

Etc for Wed, Thur, Fri, Sat, Sun.
There are 30 positions for each day of the week.

I want to move the person in slot 2 to any blank slot, say 4, for all seven
days of the week.

"David" wrote:

I have a range that I use with an autofilter of 30 people for each day of the
week, each labeled in Column A as 1,2,3...30, etc., with the same number for
each person for each day. The same person would be on a row labeled 1 for M,
T, W, etc., the next person 2 for M, T, W, etc., etc.
I have a macro that shows only the ACTIVE people, so the user may only use
the first 6 people, for each day of the week.
Their information is also tied to a specific sheet in another workbook with
their weekly data. When a person leaves, I want to move this person from
their slot into a non-used slot (like 29, 28, 27, etc), along with their
corresponding data in the other worksheet. Moving the data in the seperate
worksheet is not an issue. I've created the program to set the number of
visible positions to 30, but I can't figure out in any SHORT way to move the
person say in slot 3 to slot 29, for all seven days of the week. The person
in slot 3, would have seven cells of data that need to be moved to seven
cells of data labled slot 29, one cell for each day of the week. Hope this
isn't confusing! I would appreaciate any help to get this wrapped up!

David