I have to run a macro to separate an account number into 7 columns. I used
the destination columns to which the data was spread for the formulas in the
destination workbook. I have 28 or 35 days in the period and a new payroll
sheet is downloaded each day and pasted into the workbook on a separate tab.
I have 35 blank tabs on a master workbook for pasting each month. Every time
the macro runs on the newly pasted in sheet, the formulas in the destination
workbook adjust to the wrong columns. Would a named range work and how would
I use it or name it to use in a linked workbook? Any help here is so
appreciated, thanks,
--
Excelsolutions4U