Good Day,
I am trying to create a VBA script that will allow the below pictured excel calendar/planner to be dynamically updated whenever the data in an excel report is updated via an InfoPath form (by Users). I have tried multiple scripts in the source book to no avail, and do not even...
To Clarify, all 26 source wb's (1 workbook for each process) are housed in the same folder on the same shared drive. They are updated daily by numerous associates while performing their individual functions, and the updated info is consolidated for each process and manually uploaded into a...
ok to expand on this question, I am currently trying to write a script that would allow me to extract data from 26 separate tables from different sources, combine them into a single table that would update automatically along with placing the data in the correct order by placing each item at the...