Good Morning,
I am trying to create VBA/ Macro that will be used to total columns F and I when the data in those specific cells match. I will be pasting data daily that is retrieved from a database into this sheet on a new tab that will be named by the date the data is pulled (Ex. 11.20.2020). I have a separate tab named Position Totals that I would like the data pulled to. If it is possible I would like for the date to be populated based on the current date. I am very new to this and probably butchered what I am actually trying to do, but any help would be greatly appreciated. I am currently inserting rows between each group and placing a COUNTA formula to total each group. I know that there has to be a more efficient way to accomplish this.
Thank you in advance,
Adam
Bookmarks