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