Hi! I'm new to this... and not so great at excel!
I have a workbook with 2 worksheets. One is named Action Items, the other is Completed Action Items.
Once an item is COMPLETE in worksheet 1, how can I get the entire row to move to worksheet 2??
Thanks!!
Take a look at this worksheet. Doing this sort of thing is a little complex.
First, I inserted a column F on your "Action Items" tab for "Actual Date Completed" as that is the criteria you are using to determine whether items are to be moved.
Then in 'Completed Action Items'!A5 dragged down
The "Action Items'!$A:$A" (shown in red) determines which column you want returned and the
Please Login or Register to view this content.
SMALL(INDEX(ROW('Action Items'!$F$5:$F$11)+NOT(ISNUMBER('Action Items'!$F$5:$F$11))*1000,0),ROW(A1))
determines which rows you want returned (ones which have dates in column F)
Is this what you wanted?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you Chemist! I input a date (as you did) in the 'actual completed date' column, but nothing moved to the 'Completed Actions' worksheet. I'd like to get that entire row deleted from worksheet 1 and moved to worksheet 2 once the 'actual completed date' (column F) has a date entered into it.
Thank you for your help, I really appreciate it!
Okay, if you want rows deleted as they are moved over to sheet 2, you'll need a VBA/macro solution. I don't have a lot of experience with that so will ask someone to help you.
Ok at the least, how do I just make it where certain cells copy to the next worksheet in certain cells?
So basically once a project is complete and a date is entered, how can you move the data (not delete it) to the 2nd worksheet?
Moving data in column A to column A in worksheet 2, data from column B to column B in worksheet 2, etc.
Did you look at my attachment? try adding dates (or removing dates) from that and see if they are transferred over. Is it not working?
Put this code in the worksheet code module
Please Login or Register to view this content.
It worked, thank you!! You saved me
If I need anything further, I'll let you know!
Thanks again!!!
One last thing, why can't I get the size the same on worksheet 2 as 1. I wanted it identical but worksheet 2 is bigger? The fonts and such are the same size...
It is the zoom factor.It is 85% on the first, 100% on the second.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks