Paste data into worksheet with macros

**Philip_T** · 07-01-2015, 12:20 PM

Hi - I apologize for my lack of proficiency in Excel jargon...

I have a worksheet that was created with macros and cell edits to do some calculations. Users would like to cut and paste data from another worksheet since manual entry would take too long.
Is there a way to paste data from another worksheet and still retain the edit's macros?

Some columns are dependent on the next C affects what values in D, etc.

I didn't see specific rules regarding file sharing but I can share the file if that helps.

**p24leclerc** · 07-01-2015, 03:49 PM

Sure, go ahead and attach your workbook. It will be easier for one of us to help you.

**Philip_T** · 07-01-2015, 04:32 PM

Here's the file link: Retirement Input File 7_1_15

It contains one line of retirement data (fictional) that a user would typically manually enter. Most have 20-50 lines, but some have 100+ and would like to cut and paste from other sources. Possibly do an import.
Once complete, they click the "Create RAD Data File For Upload" button on the right to remove macros and save to a specified file name.