macro to copy info to other tab-sheets, then print those sheets

[zatarra]

I need a macro that will do this:

***************
tab-sheet A
Name Age Height Weight
Bob 30 72 200 "macro button here"
Joe 25 68 165 "macro button here"

tab-sheet B
BoB age*height/weight = number1 number1*age = another number2

tab-sheet C
Bob Age height + weight = number3 number3/weight = number 4

***************
I need the buttons in tab A to pass 'that rows information' into cells on tab B and C, and i know how to do this but- I need the tabs
to calculate the formulas in certain cells, and then print out that tab-sheet. I could make a HUGE spreadsheet with 1000 tabs to do this, but there must be a way to just repopulate the spreadsheet tabs B and C with info and print those. None of the calculations i am doing need to move between different tab-sheets, they just need to recalculate each time i populate and print them.

Help!
and thanks!

[arlu1201]

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[zatarra]

Here is a sample of the workbook (simplified)

A couple of things:

I enter the data to the Roster tab manually and then populate out to the subsequent tabs, I know I could
do this by having a billion tabs (3 for each person), but there must be a way to recycle the data through
the Da5500,Counseling1,Counseling2 tabs without having to spam out tabs.

1) The 'Current BodyFat%' is calculated in the 'Male Tables' tab by finding the intersection of height and
circumference value; circumference value =(avg abdomen - avg neck) ; need to know how to do that

2) The button at the end of each row of the Roster tab would populate the DA5500 and both counseling Tabs
then print out the DA5500 and both counseling tabs. Have no clue how to do this.

Thanks in advance

So is this even possible to do? or do i need another program and not excel?

[zatarra]

anyone have advice here?