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!
Bookmarks