How do I write a macro that will paste a range of information (A2:X2) from
various workbooks of the same type and format to the next available line in a
secondary summary workbook? Secondly, if I create this macro in a workbook
and do "save as" will everything translate over correctly when I put in new
information? Basically what I'm doing is using the summary page to link to
Access for cost tracking purposes.