S
Simon Murphy
Use subtotal function - this ingores hidden ranges
Use the 'ignore hidden' button after selecting a range to
copy us the visible cells. this button is 4 black squares
in a square, second from bottom of edit command menu.
cheers
Simon
Use the 'ignore hidden' button after selecting a range to
copy us the visible cells. this button is 4 black squares
in a square, second from bottom of edit command menu.
cheers
Simon