Is there a way to create a sheet with two columns, one a text string, the other a boolean value, and then use the boolean field to determine whether the text string prints?
Sue wants to create a shopping list in which she has her regular shopping, and then be able to tick off the stuff she wants, leaving the unwanted items unprinted. I can't work out a way to do it, not really using spreadsheets much and having cut my teeth on Quattro Pro anyway.
Thanks.
We used to do that but have now progressed to an A5 piece of paper and a Biro. >:D
That's where I'm heading fast, Steve - though I prefer a roller-ball. :)
That's an interesting conundrum. The 'Hide' command under 'Cells' > 'Format' would probably stop the row being printed but that's messy. You could almost certainly write a macro to do it using an if/then/else loop or perhaps get my daughter to write a Visual Basic program to read the sheet and output the require list!
A macro would be the real answer. If you get stuck I might be able to knock one up.
Thanks, Zap. I'll have a dig around. This really should be so simple to implement. :)
http://exceltemplate.net/other/grocery-list/ maybe?
That's no good, it's American, Rik needs a shopping list. :evil:
Actually I think Conditional Formatting (under the Styles group) is possibly the way to do it (if Steve's suggestion doesn't work).
Mine's too complicated but the 'macros' maybe there?
Thanks, Steve, that may be the answer, provided I can modify it. :)
Quote from: zappaDPJ on Oct 28, 2010, 18:02:56
Actually I think Conditional Formatting (under the Styles group) is possibly the way to do it (if Steve's suggestion doesn't work).
Thanks, Zap, another route to consider.
For some reason, the things that seem as though they should be the simplest, are often the most difficult!
Story of my life ;D
Do what I did, and give up. I just manually delete rows, then restore to the original file the next week.
That's what I've done for my customer database. I was going to use Open offices version of Access. But it just did not work the way I wanted it to (address fields, auto population of dates ect), and my programming/macro skills are zero. So I've done it all by hand. :P
I may just do that, though Steve's template looks possible.