Print rows based on cell value

**Gerhardvanzyl1** · 01-17-2023, 07:00 AM

Good day Everyone. Hope everything is well.

I need assistance with printing a sheet based on a cell value

I have a sheet called ITEMS, there is data from cell C5 to J393. In Column F5 to F393, I have qty column(I would put a quantity). I need a code so that only rows with a value higher that 0 in F to be printed preview in PDF(Already have a print button)

You assistance would be greatly appreciated.

Thanks

Gerhard van Zyl

**davesexcel** · 01-17-2023, 09:04 AM

Select the header row,
Select ribbon Data=>Filter=>Number Filters=>Greater Than=>Enter 0 in the box and click ok

Once you have practiced that, you can use the macro recorder to get a code.

-
2023-01-17_07-00-28.jpg

**Gerhardvanzyl1** · 01-17-2023, 09:31 AM

Hi davesexcel,

I would prefer a VBA code for my print button. Easier to just click on print button and it will only print rows with a value in F column.

Thanks

**davesexcel** · 01-17-2023, 09:36 AM

I was explaining to you what to do, then use the macro recorder to get the code.

**Gerhardvanzyl1** · 01-17-2023, 09:44 AM

Hi davesexcel,

Thank You. Done

Print rows based on cell value

LinkBack

Thread Tools

Rate This Thread

Display

Print rows based on cell value

Re: Print rows based on cell value

Re: Print rows based on cell value

Re: Print rows based on cell value

Re: Print rows based on cell value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Print certain rows of certain columns based on variable

[SOLVED] Print selected rows based on cell data

Print Rows Based on Value in Column A

[SOLVED] Vba code assistance to print rows based on column date value

VBA code to print rows based on value in select column

Print Rows Based on Input

Selectively print rows based on cell data

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions