Append new data from one worksheet to a master worksheet everyday

[Daronsalmons]

Hi I'm after a little help, I've looked through various posts but can't seem to find exactly what I'm after.


I have two workbooks one of which is a master, I want to copy the data from workbook 2 and append it to the master workbook workbook, then the next day do the same thing again.


any help really appreciated.

Daron

 

[My Aswer Is This]

Your subject title says:

Append new data from one ​

worksheet​

to a master ​

worksheet​

everyday​

But then you say:

I have two ​

workbooks​

one of which is a master, I want to copy the data from workbook 2 and append it to the master ​

workbook workbook

​

So are we talking about two Worksheets or two Workbooks?

And if Worksheets What are the names of these two sheets?​

​

​

 

[Daronsalmons]

Sorry I have two workbooks

Workbook Name = "Timesheets" (Sheet Name = "Timesheet") (CSV File)

The other is:
Workbook Name = "Master Timesheet" (Sheet Name = "Master Records") (excel macro enabled workbook)

Hope this helps

 

[My Aswer Is This]

Sorry I have two workbooks

Workbook Name = "Timesheets" (Sheet Name = "Timesheet") (CSV File)

The other is:
Workbook Name = "Master Timesheet" (Sheet Name = "Master Records") (excel macro enabled workbook)

Hope this helps

I have never worked with CSV files.

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.