MACRO - I think.

  • Thread starter Thread starter Dick
  • Start date Start date
D

Dick

I have a spreadsheet with 3 columns - A, B, C. Column "A" is randomly
populated with data. I.e., a1, a6, a36, a135 may have data but the other
cells in column "A" are blank. I want to create a Macro (I think) so that I
can print ONLY the rows that contain information in column "A". In other
words some way to simply select a process, a macro, that I could simply click
and the result would be a print of columns A, B, and C but only for the rows
that contain information in the "A" column. If there is a way other than a
macro, I am certainly open for that.
 
Hi Dick,

Try auto Filtering. (Procedure in XL 2003)
Select the entire column (A in this case)
Select Data from the main menu
Select AutFilter

On the spreadsheet in cloumn A you should see a down pointing arrow in A1
and press it.
Select (Non Blanks)

This should give you what you are looking for. Please press Yes if this
helped.

John
 
Back
Top