I need to export the data into an existing excel sheet and have it overwrite the data that is already there (because these are monthly reports).
I have searched around and everyone keeps referring to VBA, but I know basically nothing about it, so can I do this by using a simple macro?
If I can just use a macro, how exactly do I specify which excel sheet to export the data to?
I have searched around and everyone keeps referring to VBA, but I know basically nothing about it, so can I do this by using a simple macro?
If I can just use a macro, how exactly do I specify which excel sheet to export the data to?
