Hi

I have a sheet ("Printing) which is populated from another sheet
("Data") which is updated by the users.

Not all the rows in the "Printing" sheet will be populated hence I
would like to print only the rows with date in it. All my rows (from
b6 to b3000) are filled with formula in it.

Could anyone please help me how to run print command so it only pick
up rows with data in it ?

Thanks,
Naeem

And you don't want to print the rows after the last entry in column b that is
not "".

If yes, then you can try this technique:
(saved from a previous post, you'll have to change the ranges)

If those formulas appear at the end of the data and you don't want to use
autofilter...

If I can pick out a column indicates if that row is used or not, then I like
this technique:

(I used column A in my sample, but you can use any column you want.)

Insert|Name|Define
Names in workbook: Sheet1!LastRow
Use this formula
Refers to: =LOOKUP(2,1/(Sheet1!$A$1:$A$1000<""),ROW(Sheet1!$A$1:$A$1000) )

(Make that 1000 big enough to extend past the last possible row.)

Then once mo
Insert|Name|Define
Names in workbook: Sheet1!Print_Area
Use this formula
Refers to: =OFFSET(Sheet1!$A$1,0,0,lastRow,3)

That last 3 represents the last column to print (A:C in my example).

And change the worksheet (sheet1) if necessary (in all the places).

Ps. If you go into file|page setup, you may find that the print range is
changed to a specific range. And you'll have to reapply the Print_Area name.

Naeem wrote:

Hi

I have a sheet ("Printing) which is populated from another sheet
("Data") which is updated by the users.

Not all the rows in the "Printing" sheet will be populated hence I
would like to print only the rows with date in it. All my rows (from
b6 to b3000) are filled with formula in it.

Could anyone please help me how to run print command so it only pick
up rows with data in it ?

Thanks,
Naeem

--

Dave Peterson

On Apr 23, 12:09*pm, Dave Peterson wrote:
And you don't want to print the rows after the last entry in column b that is
not "".

If yes, then you can try this technique:
(saved from a previous post, you'll have to change the ranges)

If those formulas appear at the end of the data and you don't want to use
autofilter...

If I can pick out a column indicates if that row is used or not, then I like
this technique:

(I used column A in my sample, but you can use any column you want.)

Insert|Name|Define
Names in workbook: *Sheet1!LastRow
Use this formula
Refers to: *=LOOKUP(2,1/(Sheet1!$A$1:$A$1000<""),ROW(Sheet1!$A$1:$A$1000) )

(Make that 1000 big enough to extend past the last possible row.)

Then once mo
Insert|Name|Define
Names in workbook: *Sheet1!Print_Area
Use this formula
Refers to: *=OFFSET(Sheet1!$A$1,0,0,lastRow,3)

That last 3 represents the last column to print (A:C in my example).

And change the worksheet (sheet1) if necessary (in all the places).

Ps. *If you go into file|page setup, you may find that the print range is
changed to a specific range. *And you'll have to reapply the Print_Area name.





Naeem wrote:

Hi

I have a sheet ("Printing) which is populated from another sheet
("Data") which is updated by the users.

Not all the rows in the "Printing" sheet will be populated hence I
would like to print only the rows with date in it. All my rows (from
b6 to b3000) are filled with formula in it.

Could anyone please help me how to run print command so it only pick
up rows with data in it ?

Thanks,
Naeem

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Hi Dave,

I am a little confused. Sorry about that.

Do I have to name the last row (in my case 3000) using Insert/Name/
Define and then call it anything.

And the formula Refers to: =LOOKUP(2,1/(Sheet1!$A$1:$A$1000<""),ROW
(Sheet1!$A$1:$A$1000)) , where does it go on the sheet ?

Thanks,
Naeem

Use
Insert|Name
(xl2003 menus)
to insert the name.

type those formulas into the Refers to box.

It's a named formula and it'll change depending on what the data in your
worksheet looks like.

You will have to change the name of the sheet in the formula to Printing.

Naeem wrote:

Hi Dave,

I am a little confused. Sorry about that.

Do I have to name the last row (in my case 3000) using Insert/Name/
Define and then call it anything.

And the formula Refers to: =LOOKUP(2,1/(Sheet1!$A$1:$A$1000<""),ROW
(Sheet1!$A$1:$A$1000)) , where does it go on the sheet ?

Thanks,
Naeem

--

Dave Peterson