I have the attached template where from within MS Access I will be pasting data from a recordset into the template columns A and B. What is the most efficient way to copy down the formula in col d ? My challenge is I do not know from day to day how many rows I will have to paste from MS Access to Excel.. In addition there is no guarantee I will have information in col c
From within MS Access
dset rs - This copys my data from MS Access into Col A-C
Note the Experts Exchange Attachment facility will not allow me to attach as template so I have attached it below as an Excel spreadsheet.