View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevebriz stevebriz is offline
external usenet poster
 
Posts: 195
Default 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?