I am looking to pull in the amount of dates by regions between these two spreadsheets. Test spreadsheet is where I want all the data to be located in and the MINI MACRO TRACKER is where I need the dates added up for. For example, TASK_325_PERMITS_APPROVED_AC (column F in Test spreadsheet) and (column N in MINI MACRO TRACKER) are the same but I need it to say Chicago for an example has 136 dates.
Attached are the two different spreadsheets.
Any help would be greatly appreciated.
Hi,
Try this in cell F2 of the TEST workbook:Formula:
Please Login or Register to view this content.
HtH,
Joris
--------------------------------------------------------------------------------
If you found my answer helpful, please hit the Like or Thank button.
Please follow the forum Rules and Guidelines and use Code tags around your VBA code.
Remember: test VBA code always on a copy of your file because usually you can't use undo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks