PDA

View Full Version : Dynamically Pulling data from other workbooks in folders



dblock247
05-30-2011, 07:30 AM
Hi I would like to say thanks for your help in advance.

Objective:
Track day to day employees and tickets they write in a daily work book. Have a master workbook that will pull in all the data from the other work books and then rank the employees on their productivity.

Important features:
1. Ability to pull in tickets and employees without duplicating the ticket numbers to ensure a tickets isn't in twice. Also to have the ability to have certain types able to be duplicated (ex. "LEAD") which are not tied to tickets
2. The ability to scan a folder and pull in data from the workbooks in there with the option to scan subfolders
3. The ability to lock in the formatting so that if the user decides to cut and paste data from another workbook it doesn't ruin the formatting


Attached is a copy of the workbook

dblock247
06-02-2011, 05:43 PM
Can someone please help?