Hello,

I have three sheets named 700, 800, 900 and other duplicate sheets named
A700, A800, A900, B700, B800, B900, etc. where 700 and A700 or B700 have the
duplicate information. Each day, I will go in sheet 700, 800 and 900 to hide
the rows that are completed (vary everyday).
How can I create a macro so that if 2 rows are hidden from sheet 700, then
it will automatically hide 2 rows from sheet A700 & B700, etc..(same for 800
and 900 sheet)? Sample of sheet 700 is:

Row A B C D E F G H I
1 Number Date Model Type ....................
2 1000 4/2/08 5000 A
3 1001 4/2/08 3000 B
4 1002 4/3/08 3000 B
5 1003 4/6/08 6000 A
6 1004 4/8/08 6000 B