View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marty Marty is offline
external usenet poster
 
Posts: 116
Default Copy and move check box (check boxes) with new cell link?

Hi,
I have created a document with text, check boxes and IF formulas dependant
on the TRUE or FALSE values for each of the check boxes. This was done over
time and it is fairly extensive at this point and I would like to duplicate
that document on the same sheet about 6 to 8 times below the original. When I
copy the document and paste it below the original (text, formulas and check
boxes), the references (cell link) for all of the check boxes are linked to
the original document (clicking a check box in the copied document add a
check mark to both the copied and original check boxes which I do not want).
I have used the "form" check boxes. Is there a way to copy and paste check
boxes and obtain a new cell reference?

Other recommendations?

Thank you.