I am attaching 2 files. My employees should be able to use "DRC Form" and at the generate a report which should look like "DRC report" which they can send to our customer.
All yellow areas should be drop down menu. You will find them in "DATA" sheet.
When a person opens this document, there will be only "issue1". By clicking on "GREEN ADD ISSUES", my employees should be able to create another issue box with no data in it. Users will use these box to add their issues. "B21 to B25"
With each issue box, the "issue number" should increase and should create its own associated sheet. There should be the little picture button in front of each issue and it should be a hyper link to its associated issue sheet.
The Cell which has "Issue#" should change color either RED or Yellow based on "stage" color coding.
The 3 cells with data input should increase in size (Start to increase down wards) if user need more space to write.
The create report button should create a report at the end. Basically a copy or the excel file with removing drop down menus and "data sheet". So the entry that user selected for drop down menus should appear at its location without the drop down menu looks.
Décerné à :
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara :)