Hello,
I am new to this community but from what I have seen you seem to be a bunch of helpful folks. I hope that you will be able to help point me in the right direction.
Right now I have a spread sheet that I use in meetings. On this workbook are a number of different sheets for different parts of the meeting. On one of these sheets we have a list of projects and in separate columns we have their description, date started, current status, etc. On another sheet, titled 2-week plan, is where we put items if their current status reads "2 week action plan". Here is a sample of the first sheet:
If under the "CurrentStatus" column it reads "2_Week_action_plan" I want to copy and paste certain information into another sheet, "2-Wk_Plan". There may be old action items already in that sheet and I don't want them to be deleted. Instead I would just like these to be copy and pasted at the end of the list. There are also cells that need to be manually filled out. I don't know if this is best accomplished with a message box and user input or if it would just be better to go to the sheet and type it into the cell(s). Here is what the next sheet looks like:
I bolded the things that would be copy and pasted and italicized the items that would need to be manually put in for each project.
Ideally I would like this to be running constantly so that right when "2_Week_action_plan" is selected on that first sheet, the bolded items are copied and pasted and either a messagebox pops up prompting the user to input the italicized portions or the next sheet is made the active sheet and the user just manually clicks on each cell and inputs the information required.
If it is not possible to be running all the time then I assume it would be possible to create a macro and attach it to a button that would then perform the tasks?
Thanks for any you all can give me. I think I know just enough about excel to get myself into trouble.
I am new to this community but from what I have seen you seem to be a bunch of helpful folks. I hope that you will be able to help point me in the right direction.
Right now I have a spread sheet that I use in meetings. On this workbook are a number of different sheets for different parts of the meeting. On one of these sheets we have a list of projects and in separate columns we have their description, date started, current status, etc. On another sheet, titled 2-week plan, is where we put items if their current status reads "2 week action plan". Here is a sample of the first sheet:
| Project | Category | EngineerResponsible | DateSubmitted | CurrentStatus | DaysLeft | ReviewDate |
| Project1 | EngineeringPhase | Smith1 | 1/1/14 | Pending | 500 | 1/1/15 |
| Project2 | Implement | Smith2 | 1/1/14 | 2 Week_action_plan | 500 | 1/1/15 |
If under the "CurrentStatus" column it reads "2_Week_action_plan" I want to copy and paste certain information into another sheet, "2-Wk_Plan". There may be old action items already in that sheet and I don't want them to be deleted. Instead I would just like these to be copy and pasted at the end of the list. There are also cells that need to be manually filled out. I don't know if this is best accomplished with a message box and user input or if it would just be better to go to the sheet and type it into the cell(s). Here is what the next sheet looks like:
| DueDate | Project | BPLAN_Item (Y/N)? | EngineerResponsible | SpecificAction | Condition of Satisfaction | Complete(Y/N)? | Constraint |
| 3/24/15 | OldProject1 | Y | Smith8 | CureCancer | Cured | N | Money |
| 7/20/15 | Project2 | Y | Smith2 | NextStepNProject | Done | Y | Money |
I bolded the things that would be copy and pasted and italicized the items that would need to be manually put in for each project.
Ideally I would like this to be running constantly so that right when "2_Week_action_plan" is selected on that first sheet, the bolded items are copied and pasted and either a messagebox pops up prompting the user to input the italicized portions or the next sheet is made the active sheet and the user just manually clicks on each cell and inputs the information required.
If it is not possible to be running all the time then I assume it would be possible to create a macro and attach it to a button that would then perform the tasks?
Thanks for any you all can give me. I think I know just enough about excel to get myself into trouble.
