One more thing ~ when I go to copy and paste link on the 2nd sheet, it won't
let me paste the link if I select the "skip blanks" option. Is there a way
around this? There's a heck of a lot of 0's on that sheet!

"gjcase" wrote:


And if your boss still insists on separate sheets, you could have each
cell on Sheets 2 & 3 = the corresponding cell on sheet A, and then
apply the filters on Sheets 2 & 3. Your boss would think you did it
his way...

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528152