exporting table to existing Excel spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I have a table that gets updated daily with sales and units sold. Once this
table is updated daily, I want to automatically export the values from that
table into a worksheet in an EXISTING Excel workbook (essentially overwriting
whatever was there the day before). I have other workbooks that reference
this one, so I need to make sure I update this one daily.

Does anyone know how I can accomplish this via VBA?

Thanks very much!
 
Please ignore this question -- I'm truly ignorant sometimes. I did some
looking around on these forums and found my answer.

Thanks!
 
Back
Top