I am creating and addin that when opened will copy itself into an
existing workbook. From there the copied worksheet is supposed to pull
data from another worksheet and allow the user to manipulate it. I
created the worksheet in the same workbook that it will be used in.
Made sure all the formulas worked as desired and that everything was
the way i wanted it to be. However, when I copy the addin worksheet to
a new workbook to actually make it an addin I loose all my references.
How do I change the formulas so that when the worksheet is copied into
the existing workbook it references the cells properly.