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
.Range("A2").CopyFromRecordset 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. Test-Template.xlsx
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.