Microsoft Excel 2007 project that will require some Macros and VB coding. I already have the templates for these sheets and some of the coding is already done, although you may want to change it to be more efficient. I will award this project quickly but need quick turnaround. Part 1 – Data Entry: There will be multiple (10+) excel files, but each one will be the exact same except for the actual figures within and the title. Each one will have two sheets (tabs): Sheet1 - data entry screen. There will be a dropdown for the user to select from a list of 36 "cycles". This dropdown is currently a Data Validator List but could be changed to something else if that makes more sense. The user will select one option from the dropdown list and then enter data into cells on Sheet1. There are 24 columns to enter data for (for 24 months) and 4 rows. Once the user enters the data, there will be a "Transfer" button at the top of the screen that will transfer what they've entered on this Sheet into Sheet2 (the raw data sheet) via a Macro. The Macro will have to know where in Sheet2 to place the data based on what the user selected in the Dropdown in Sheet1. Once that is done, the cycle just repeats, the user can then choose a different option from the dropdown at the top, the data on the screen will refresh (based on VLOOKUPS to Sheet2), and then they can enter more data for that "cycle" and then when they are happy, they again hit the "Transfer" button to commit that data to Sheet2. Part 2 - Collecting all data: A master excel workbook sheet would have a button attached to a Macro that collects data from the "sheet2" of all the individual files in Part1 into one massive data dump. All the files in part1 will reside in the same directory. Part 3- Reporting: One final sheet is the "report" based on the data in the file from Part 2. It would simply summarize data from the file in part 2. Desired Skills: VBA Visual Basic excel Keywords: Other IT & Programming, Basic, VBA, excel, Visual