Jimmy Nguyen
New Member
- Joined
- Mar 22, 2011
- Messages
- 1
Hi there everyone, I am new with excel and currently using excel 2003 and I have been asked by my manager to create an action item list and would appreciate anyones help! I've searched through the forums and I cannot find anything that will help me!
What I need is a macro code/button that will:
1) create a button (that will be placed in the sheet called 'New') to DELETE/CUT entire rows and paste them to the first blank rows in either one of the three work sheets: OEM, OPERATORS, SUPPLIERS based on what word is put in the RELATIONSHIP (Column L) which can either be: OEM, OPERATORS, SUPPLIERS.
2) for each of the 3 worksheets mentioned above; OEM, OPERATORS, SUPPLIERS, I would like to have a button on each of the sheets that will DELETE/CUT entire rows and paste them to the first blank row in the 'Archive' sheet based on the STATUS (Column L) and if it says "Closed".
The sheets all have the exact same layout and all the columns are the same. Basically, sheet one (new) is used to put in new action items, sheet two is a summary of the open/active action items, and sheet 3 is an archive of closed action items.
Can anyone help???? Please and thank you
What I need is a macro code/button that will:
1) create a button (that will be placed in the sheet called 'New') to DELETE/CUT entire rows and paste them to the first blank rows in either one of the three work sheets: OEM, OPERATORS, SUPPLIERS based on what word is put in the RELATIONSHIP (Column L) which can either be: OEM, OPERATORS, SUPPLIERS.
2) for each of the 3 worksheets mentioned above; OEM, OPERATORS, SUPPLIERS, I would like to have a button on each of the sheets that will DELETE/CUT entire rows and paste them to the first blank row in the 'Archive' sheet based on the STATUS (Column L) and if it says "Closed".
The sheets all have the exact same layout and all the columns are the same. Basically, sheet one (new) is used to put in new action items, sheet two is a summary of the open/active action items, and sheet 3 is an archive of closed action items.
Can anyone help???? Please and thank you
Last edited:
