I have created a spreadsheet for internal use in my workplace that logs task by members of staff,
What I am trying to achieve is when someone selects from a drop down box that a task has been complete I want the task to automatically move to another worksheet for the relevant month, as I will have worksheets for every month logging all the past tasks that have been assigned.
I believe an IF statement should do the trick, but I am having no luck so far.
Many Thanks In Advance
A function like IF or VLOOKUP won't move anything, it can just allow things to be mimicked on a second sheet. If you want a row of data to be physically moved based on the content of a single cell in that row, you'll need VBA code to make that happen.
Post a question in the Excel Programming forum regarding it.
I'm going to suggest you include an "are you sure you want to change this to COMPLETE and move the task?" popup box in case someone accidentally clicks on COMPLETE...there would typically be no "undo" feature letting them move it back.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Many Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks