VBA Calculation Button

  • Thread starter Thread starter MoneMike
  • Start date Start date
M

MoneMike

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
 
MoneMike said:
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
Click to expand...

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