Please, please, please help this is the very last peice of a very large project.
I need a macro that will pull the information from the register and enter next to the correct date the count in column F of the chargebacks tab & the sum of $$ in column G of the chargebacks tab.
If the data on the register matches the following criteria I need it to put the total next to the correct date on the chargebacks tab.
Column E = 6
Column H = REFER, CLOSE, STOP, NSF
Column A NOT = Z99999
Looks more like something that would be better handled with formulas.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Try this for the count...
=SUM(COUNTIFS(Register!D:D,[@Date],Register!E:E,6,Register!H:H,{"REFER","CLOSE","STOP","NSF"},Register!A:A,"<>Z99999"))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi jscalem
If the Formula approach works for you, fine.
If not, try this...
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
If you want a count
Formula:
Please Login or Register to view this content.
Enter with Ctrl + Shift + Enter
If you want the total from column E make a helper column U on the Register and enter this formula and fill down.
Formula:Please Login or Register to view this content.
Enter this formula for the sum
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
I apologize but I forgot to mention that the data on the register will change regularly. So I will need it to enter in the data for the new dates each time the macro is run but not remove the previous dates data. This is why I need a macro instead of a formula.
I have a large Macro that does everything else. This one thing I am having a hard time getting accomplished.
This works PERFECT!!!! Thank you very very much!!!Originally Posted by jaslake
Hi jscalem
If the Formula approach works for you, fine.
If not, try this...
Please Login or Register to view this content.
You're welcome...glad I could help. Thanks for the Rep.
If this resolves your issue please mark the Thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
So I thought this was solved however when I run the macro if there is nothing that matches this criteria it gives me a runtime error on the following line
HTML Code:
Hi jscalem
Try this...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks