EDIT: Please note that I did not mention at first I posted this question on another excel forum, here's a link.
http://www.mrexcel.com/forum/showthread.php?t=345819
Hi,
this is my first post and as I gave a look around I could not find anything like this so please do not flame me if this is a stupid question.
This is of course a simple example, so please do not comment on my diet
Suppose I am currently planning my shopping on a weekly basis, and go shopping to a big convenience store weekly.
It makes sense for me to bring my laptop with me and keep it on my shopping cart because I will be interested in the totals of each column, and I can't count .
DIET SHEET Lattice Tomatoes Carrots Oranges Apricots Bananas Pasta Steak Fish
Sunday 1 1 1 1
Monday 2 1 2
Tuesday 3 2
Wednesday 1 1 1 1 1
Thursday 1 2 1 2
Friday 1 1 1 3 1
Saturday 1 1 2 1 1
WEEK 8 3 4 5 2 3 4 2 7
Now suppose I am planning to move downtown, I will have to sell my car so I will do my grocery shopping daily by feet.
My old laptop is too heavy so I want to print a sheet every day that lists only the objects that are there, without mentioning the items that are = 0; please note this is important, otherwise I will be SO utterly confused that I would soon find myself in a restaurant, or worse.
More or less like this:
DIET SHEET
Sunday
Lattice 1
Carrots 1
Oranges 1
Steak 1
...
DIET SHEET Monday
Tomatoes 2
Bananas 1
Fish 2
... and so on...
Is there any smart and effortless way to do this, without having to copy and paste special / transpond and delete manually the empty lines? Any macros?
Thanks!
Bookmarks