Hi my VBA coding skill is quite rusted as I haven't done it for a while. I am peforming the transaction analysis and hope to use some VBA code to avoid some manual work.
Basically, there are two tab in this scenario. Tab A has the list of the names in which Tab B include all the detail transactions such as name, purchases, month, flag,etc. I need to refer the Tab A for the listed names and then used the Tab B to produce the summary result that listed the name, month, and flag. BTW, Tab B has included transactions from Jan 2010 to March 2011. But my selection only needs to include Jan 2011 to Mar 2011.
Any advices are greatly appreciated.
Basically, there are two tab in this scenario. Tab A has the list of the names in which Tab B include all the detail transactions such as name, purchases, month, flag,etc. I need to refer the Tab A for the listed names and then used the Tab B to produce the summary result that listed the name, month, and flag. BTW, Tab B has included transactions from Jan 2010 to March 2011. But my selection only needs to include Jan 2011 to Mar 2011.
Any advices are greatly appreciated.
