VBA Calculation Button
 

I am working with a multi-sheet excel workbook and have added a
"calculate button" to sheet "A". When I click calculate, I need to
pull several seperate sections from sheet "B" and paste accordingly to
Sheets "C" "D" "E", etc. I assume this is best suited as a VBA
function becasue it should only copy the appropriate rows from Sheet"B"
if teh corrosponding check-box on sheet "A" has been market TRUE.

Any advice? Has this been done before?

Thanks,

-M

VBA Calculation Button
 

MoneMike wrote:
I am working with a multi-sheet excel workbook and have added a
"calculate button" to sheet "A". When I click calculate, I need to
pull several seperate sections from sheet "B" and paste accordingly to
Sheets "C" "D" "E", etc. I assume this is best suited as a VBA
function becasue it should only copy the appropriate rows from Sheet"B"
if teh corrosponding check-box on sheet "A" has been market TRUE.

Any advice? Has this been done before?

Thanks,

-M

Will the sections from sheet B be pasted to the the same cells on the
other sheets?