Hello,
Thank you for letting me in this forum. I'm new to this so I'm not sure what to expect. I will try to make this as simple as I can.
I have a workbook with two sheets. The items in sheet 1 change daily. The items in sheet 2 are constant. So, sheet 2 is food and their values. Sheet 1 is food consumed today. So, in sheet 2 I have (A1)Apple (A2 Calories) 30 (A3Carbs) 5 and so on. What I want is, if I type Apple in any (A1) cell on sheet 1 the rest of the data to be filled in from (Apple) Row on sheet 2.
My mother has lung cancer and is not eating well. She thinks she is eating enough. So, I created this work book to track what she eats so we can see exactly how many calories she is getting each day. I have been, copy past, copy past and that works fine. But, it would be real slick if it would do it for me.
Thank you very much for your time.
Bookmarks