I am on a diet to lose weight - it is working and I have decided to create my own calorie plan (see attachment).
In columns "D-J" I select which food I require for pre breakfast, breakfast, morning tea, lunch, afternoon tea, dinner and before bed.
The calorie count should not exceed 1800 - at least that is the plan. See R85.
What I want to do is to create a printed document (exampled in O1:V63).
I am a newbie but learning quickly.
Can you assist?
question.....
is there a specific reason why you require it copied onto another sheet?
you can set print area on your sheet between o1:v63 and everytime you print it will be that area?
i have set print area as advised into your example
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I need a formula or function (I think) that enables me to read the data in columns A-J and create a meal plan as demonstrated in columns O-V.
was actually a little harder than i thought it was going to be
i transferred the main data sheet on sheet 2 and insert a helper row to get row header down to line level (column A)
after which i used the CSE formula (ctrl+shift+enter to get the {} around the formula)
Formula:
Please Login or Register to view this content.
assumption i took was you cannot have more than 6 items per meal per day..this based on your previous template...if you want more you can just fill down the formulas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks