Hi, I'm a beginner with macros and was hoping someone could help me prepare one
I'm preparing a workbook to help project managers estimate project costs and revenues. I have an input sheet ("Start") in which they would enter some basic info about the project. In cells G55:J79 of that sheet, there is a table that the managers can use to enter info about project deliverables. The table looks like this:
Name | Start Date | End Date | Price
Requirement Analysis | 8/16/2011 | 9/16/2011 | $75,000
System Implementation | 9/16/2011 | 10/16/2011 | $100,000
I prepared a separate worksheet that I want to use as a template to look at the specific costs and revenues of each deliverable. This sheet is called "DelDetail". What I'm hoping to make is a command box that creates (and names according to the deliverable's name) a new "DelDetail" worksheet for each deliverable on the table above.
Additionally, the "DelDetail" worksheet has cells for a Start Date, End Date and Price (C7, C8 and C10, respectively). I would like those cells to be filled by the info in the "Start" sheet when the manager runs the macro.
So for example, if the info on the above table is entered in the Start sheet, I want the macro to create two new "DelDetail" sheets named "Requirement Analysis" and "System Implementation". Cell C7 of those new sheets should contain the Start Date, C8 would have the End Date and the price would be on cell C10.
I wanted to prepare a macro made up of two parts - a loop to to see if a see if a sheet already exists for the deliverable, and a function to create the sheet if it does not exist. However, I don't understand the For Next Loop very well yet, and I could not do it.
Any help would be greatly appreciated. If any additional info is needed, let me know...I tried to put as much as I could in the post.
Thanks!
Bookmarks