View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jd64361@gmail.com is offline
external usenet poster
 
Posts: 18
Default Macro for check box

I have the following information:
Column A Column B Column C
Revenue 1000.0 1200.0 1300.0
Expense $500.00 $300.00 $200.00
Margin $500.00 $900.00 $1,100.00

I am adding a check box in the bottom of each column and I need to
created a macro that when I check the box (true) it will copy and
paste as a value the data above the check box.
thanks for your help.

Pantera