Auto-logging worksheets

[Vato Loco]

I am currently using the below formula to auto save invoices for review
Is there a way that as these accumulate (there are many), that
spreadsheet could log them? I still want them to archive, but i want
report to be generated on a single sheet daily. Here is the formula
am using for the archiving:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
ActiveWorkbook.SaveAs FileName:="J:\builders choice completed\"
ActiveSheet.Range("a9")
End Sub

Thanks in advance, Vato

 

[Dave Peterson]

Maybe you could copy and paste special|Values to a different worksheet (in a
different workbook)--just the cells that are worth saving.