Hi, I'm new and I'm not actually a programmer, but I'm trying to make a little quoting program in excel. I generally understand what code is doing or asking for, but I need help setting it up.
I'm running Excel 2003, WinXP.
I have a number of rows grouped into what I call "modules" that vary but are about 12 rows high or so each. I use a check box to reveal or hide them as need be.
This of course increases the length of the data on the page I print. When I add more modules, it breaks up some of the modules at the end of the page.
What I'd like to do is have an automatic page break if the module gets split up, like instead of showing the first 3 rows on one page and the last 9 on the next, I'd prefer if it just made a page break at the end of the previous module.
Also, at the very end of my little quoting sheet, I have about 40 rows that I use to help me calculate quantities for things. I don't use this form all the time so it just wastes paper. I would like it to print (on it's own page) ONLY IF certain cells are filled in or if certain cells <> "ok" or whatever I've set up.
Can someone help me with this? I've searched through the forums already and some solutions seem close, but as I'm not too familiar with programming, I don't think I have the ability to tweak what I've found.
I would appreciate any help. Thank you!
I'm running Excel 2003, WinXP.
I have a number of rows grouped into what I call "modules" that vary but are about 12 rows high or so each. I use a check box to reveal or hide them as need be.
This of course increases the length of the data on the page I print. When I add more modules, it breaks up some of the modules at the end of the page.
What I'd like to do is have an automatic page break if the module gets split up, like instead of showing the first 3 rows on one page and the last 9 on the next, I'd prefer if it just made a page break at the end of the previous module.
Also, at the very end of my little quoting sheet, I have about 40 rows that I use to help me calculate quantities for things. I don't use this form all the time so it just wastes paper. I would like it to print (on it's own page) ONLY IF certain cells are filled in or if certain cells <> "ok" or whatever I've set up.
Can someone help me with this? I've searched through the forums already and some solutions seem close, but as I'm not too familiar with programming, I don't think I have the ability to tweak what I've found.
I would appreciate any help. Thank you!