okay i ran this on a saturday, and i noticed that the correct data is not necessaily pulling.



i have enclosed the actual spreadsheet that i created. With names fully on it.

when i ran it with all the name back in it, the dollar amounts were not correct for vendors. Case in point...Dick Blaske it showed a dollar amount of 6.00 when it should be 18.00

Thank you,

2013 Membership Attendance.xlsx

The attached workbook is .xlsx, not .xlsm, so I can't tell what, if anything, might be wrong with the VBA code that created it. But for what it's worth, when I open this I see a bunch of 18s next to Dick Blaske's name; 18, not 6. Dunno whether I'm simply looking at the wrong row, or our Excels are acting differently, or what.

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.

2013 Membership Attendance With Macro.xls

I see the issue. It appears that y was set to 8 rather than 3. Not sure how that happened. I will fix this and repost.

Thank you so much. This really does solve my problem very well.

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.

Attached Files

2013 Membership Attendance With Macro2.xls (147.5 KB, 15 views)

Dude it works absolutely perfect. Thank you so much

Jonathan

You are very welcome I appreciate the opportunity to work on it as it really helps me learn as well.