Need help filling table cell using same and another table

[ExcellVBUser]

Hey,
I'll try to explain as best as i can.
I have a table that is created using a form with one text box and some check boxes. User puts name in text box and checks the items, then clicks a button that adds(or checks for) their name in the table, and puts the items in the row of that name. And i want to check which items were checked for the current user.

In another table i have the info on the Items that can be picked
so...
Items: Beans, MushroomSoup, SlicedPeaches, FriedOnions
ItemInfo: Calories, TotalFat,Choesterol, Sodium, TotalCarbohydrate
Users: user1, user2, user3, user4

In the table that is made by the form, I've left columns for the totals of each ItemInfo between the names of users and the items picked.

How can i make it check which items the user picked, then put the totals from only those items info in each column.


thanks for your help

marc

 

[ExcellVBUser]

This is the make-shift table 1

headings are UserName in column  "A"
             Calories in          "D"
             TotalFat in          "E"
             Choesterol in        "F"
             Sodium in            "G"
             TotalCarbohydrate in "H"
             Item1                   "Z"
             Item2                   "AA"
             Item3                   "AB"
             Item4                   "AC"
             Item5                   "AD"

user1-user4 are in column "A" starting at Row2
A            D         E        F         G       H             Z      AA    AB     AC     AD
UserName  Calories  TotalFat  Cholest  Sodium  TotalCarb      Item1  Item2  Item3  Item4  Item5
user1	                                                      Item1         Item3  Item4  Item5
user2	                                                      Item1         Item3         Item5
user3	                                                      		    Item3  Item4  Item5
user4	                                                      Item1  Item2  Item3  Item4  Item5

And this is make-shift table 2

headings:    UserName in          "A"
             Calories in          "B"
             TotalFat in          "C"
             Choesterol in        "D"
             Sodium in            "E"
             TotalCarbohydrate in "F"

user1-user4 are in column "A" starting at Row2
  A               B            C          D      E            F
UserName    Calories    TotalFat      Cholest    Sodium     TotalCarb
Item1          100            6          5            900            11
Item2          20              0         0            370             4
Item3          60              0         0            10              15
Item4          45              3.5        0            60               3

ray: can anyone help?

marc


edit: Guess i should say that i need the totals in Columns "D" "E" "F" "G" "H"

 

[ExcellVBUser]

should i try another layout?
maybe a sheet per table, making three sheets.....
Or should i have a sheet per user?

can anyone point me to something that might help?