Hi All,
Hoping someone can help with this project, its way beyond my knowledge of excel.
This is in two parts, first I’m trying to copy the same information from many files in a folder, and they will look like the attached “PCN 2014 Test” workbook (PCN Form Tab), but will have a name like PCN12345 and copy the info to my “PCN Data” workbook. The cells I’m trying to copy in the “PCN 2014 Test” workbook are the PCN Number cell P1, Names & Dates in cells H4 thru Q10 which are in drop down list and the date auto-populates, also PCN Type cell D13 which is also a drop down list. Note: Many of the cells in the “PCN 2014” workbook have Defined Names.
Then in the “PCN Data” workbook (Issued Tab) a button (see attached) would be pushed to drop in the info into columns A, B, D & E (multiple PCN’s). Then hoping once the PCN’s have been processed from the “Issued” folder (this issued folder is where we store the completed PCN’s) the PCN’s could then be moved into a folder that is in the same location as the PCN’s are, like a “Processed PCN File” folder. When the PCN Data workbook is opened a week later, the user would click the button again and the list would keep growing as more PCN’s are completed. There are many PCN's and plans to do pivot tables and charts from the PCN data workbook.
Part two if possible, is to pull the same info as above from the PCN forms (when button is pushed) but pull the PCN’s from a different folder; this folder sits next to the “Issued” folder above and its call “Change Notice”. It has all the PCN’s that are in process (but not complete) and would like to copy same info to the “PCN Data” workbook but on the (Change Notice Tab) instead of the (Issued Tab). This will let us see what department has the PCN and once I get the formulas working we can see how many days they have been sitting on them.
We are trying to see how long a PCN takes to get thru the entire process and also monitor the PCN’s that are still in process and where they are at.
Hope this is not too confusing and that someone can help.
Thanks,
Bikeman
Bookmarks