Quote:
Originally Posted by jonpackbosoxfan
Okay now I have enclosed the one with the macros in it plus all the data. If you compate the data in the Saturday/Wednesday (which is correct) and the data that goes into the printout workbook, you will see that the correct dollar amounts is not being associated with the right people. Please help. Thank you.
Attachment 3626 |
Again my apologies. Believe it or not I have only been vba coding for a couple of months now. This code needed another variable and the 2 worksheets needed to be consistent (rows 1 and 2 on Wednesday were merged) I tested it with the 1st column of each and it appears to work now.
I have some experience with creating macros in access and it sounds like you will need to set up a paste append macro in access and set up a table worksheet in your workbook to do this.
Sorry again hope this works now.