So I have a workbook that is employee records for each month. We save the excel document as "Smith AUG 11." Almost 100 different workbooks each month. Is it possible for me to pull data from all of these different workbooks into a single main workbook for data analysis? For instance I have three cells lets say A55, A57, A59, and I want to take whatever is entered into these cells and automatically update the "main" workbook which will keep track of how many times a data entry is entered into these cells. Lets say I enter A01A into one of those three cells above on one persons document, and the same A01A in someone elses document, with the end result being the "main" workbook keeps track of how many times A01A is entered? Thank you for your time, and any help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks