macros need help

[necalli]

Need help with a code that will copy data from one spreadsheet that contains only one worksheet. (this is a CVS file exported daily from our software) and paste it into another spreadsheet that has multiple worksheets to a specific worksheet within that spreadsheet. I need a code that will copy a certain exported file into another spreadsheet into a certain worksheet.

The objective is to automatically update data dumped from the software daily these can be around 50 spreadsheets and not have to copy and paste each single file into the spreadsheet that will contain the multiple worksheets. I have to show a trend graph daily.

 

[Smitty]

Welcome to the Board!

I'd start by recording a macro doing what you want, as that will capture the correct directory/file path.

Feel free to post back what you get and someone can help you clean it up.

 

[necalli]

I am getting errors even if I do it how I want it

 

[Smitty]

You'd need to post the code and indicate where it's failing.

 

[MARK858]

If you are getting errors when you are recording the code when doing it manually best you post what the error is you are getting back.

Edit: Smitty said it first but I'll leave it here as looks better than leaving it blank (unless Smitty deletes it which is tidier still)