If statement for populating data

idonaldson

New Member
Joined
Jan 24, 2012
Messages
1
Hello,

First post, long time lurker. I've found many answers to numerous questions over the years on this great site, but I finally have one I can't seem to find a solution for.

I have 2 sheets in this work book. Sheet 1 is a form for receiving in material, and sheet 2 is layed out to print Avery 5978 (2X4) shipping labels with info from sheet 1. I need to be able to determine which shipping labels on the page to print. My first thoughts, coming from java programming, would be some kind of If..then statement like the following:

If(Sheet1!O5 != Blank) {
Sheet2!A1:B6 = visible
}

Which would check all 10 cells for some sort of mark, probably just an X.

On sheet 1 I just have 5x2 cells marked out, and if there is an X in the box, that should allow that corresponding label to get printed off of sheet 2. I was trying to tie this all to a button and grid on sheet 1. I have the button that will print out sheet 2, but it currently prints all the data.

Any thoughts?
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top