Automatically moving a row from one worksheet to another when date completed added
Hi All,
I am a mediocre Excel user who needs a bit of help. Worryingly my company thinks I'm good at Excel. The truth is the rest of them are just not even as good as me!
I am trying to revamp their project spreadsheet to be easier to complete. I have added some simple things like conditional formatting for RAG status, but what I would really love to do is find a way to automatically move a row out of the Open Projects worksheet when the 'Date Completed' field has a date added, and into the next free row in the Closed Projects worksheet.
From what I can tell it seems to something that can be achieved using VBA, and either found some code that someone created on another forum. But my knowledge is that weak that even when I believe I am following the steps correctly, I end up with errors I can't resolve. I'm sure this is probably very simple for some of you guys. Can anyone help me with this? I have attached a copy of the document so that you can see what I am trying to do.
Appreciate any help.
Colin
| Attachment | Size |
|---|---|
| Project List.xlsx | 10.63 KB |
hi Colin... what you're
hi Colin... what you're trying to do should never need to be done if you change the way you use spreadsheets.
recommend thinking about a restructure of your spreadsheet process:
- Current state:
- data and reports are the same thing
- Future state
- separate data from reports
- hold all data in the same place, and create reports that summarise that data, and get updated on demand
- pivot tables are the best way to create reports
some routines that may help you..
http://excelexperts.com/excel-experts-xla
... if you are determined to proceed with current state, have a look at:
EE_FilterAndMove or EE_Copy
Nick
Thanks
Hi Nick,
That all makes sense....thanks. I have done both; the pivot tables are summarizing the data and the VBA codes have helped the team in minimizing the process, as maintaining the spreadsheets are a visible thing for the Directors.
Thanks again for your advice.
Colin