Hi,
I will try and explain as best I can. I have a speadsheet that is more
akin to a database table. It is quite large and has been designed for
2000 records (rows). It has an autofilter on the top row which is used
to sort records for information purposes. The spreadsheet is basically
your standard employee database with staff numbers, names, addresses,
and other work type info.

Here is what I want to do. I would like to be able to use a macro so
that at a touch of a button a sheet pops out the printer with the info
I want. I have a format for the info to go into and I can do all the
other bits however; I do not know how to only copy ONLY the filtered
cells containing text. Because there is no standard amount of rows I
end up with 180+ pages of blank poping out of the printer.

Is ther some way so that when I use a filter or custom view/sort, I can
copy only certain columns of info and only the rows that contain
information.

I am sorry if I have not explained this very well but I would be
grateful for and help.

Regards

G


--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143
View this thread: http://www.excelforum.com/showthread...hreadid=570660