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?
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?