M
Margaret_ev
I have a template where I have cells with formula. I have created outputs from Access which have these columns as blanks. When I paste the data into the template sheet, requesting Paste Special, Values, and Skip Blanks, I thought it would ignore the blank columns and leave my formula intact, but it writes the blank columns in
Is there anyway of pasting the data in without overwriting the formula
As an example my sheet will look like this
text field / text field / text field / currency field / blank field / text field
The template will have a formula to calcuated in the blank field
Appreciate your help as it is frustrating to have to redo the formula's each mont
Regard
Margaret
Is there anyway of pasting the data in without overwriting the formula
As an example my sheet will look like this
text field / text field / text field / currency field / blank field / text field
The template will have a formula to calcuated in the blank field
Appreciate your help as it is frustrating to have to redo the formula's each mont
Regard
Margaret