I have a list of items on one sheet. This list is used for reviewing tasks that need to be completed. I would love to be able to mark something complete and have it move to another tab of items complete.
Is this possible?
I have a list of items on one sheet. This list is used for reviewing tasks that need to be completed. I would love to be able to mark something complete and have it move to another tab of items complete.
Is this possible?
Last edited by Kcadzow; 01-18-2024 at 02:57 PM.
Yes. Will probably need to employ VBA.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I'd like to automatically have completed items move to the "PPAP Complete" tab as soon as column J on "In Process" tab shows complete.
Currently, there is a formula to change column J to complete when information is put in the reviewed column (Column I).
The process right now is cutting, pasting then deleting the columns. Just wondering if it is possible to have all that happen automatically.
When I enter data in column I, the row changes to green and column J changes to "Closed" not "Complete". Please clarify in detail.Currently, there is a formula to change column J to complete when information is put in the reviewed column (Column I).
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Correct. It changes to "Closed" which means complete.
Sorry for the confusion.
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "PPAP in Process" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter a value in column I and press the RETURN Key.
Please Login or Register to view this content.
According to post #3 attachment a VBA event procedure to paste only to PPAP in Process worksheet module :
PHP Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 9 And Target.Row > 1 And Not IsEmpty(Target(1)) Then
Application.EnableEvents = False
With Rows(Target.Row)
Sheet3.Cells(Rows.Count, 2).End(xlUp)(2, 0).Resize(, 10) = .Range("A1:J1").Value
.Delete
End With
Application.EnableEvents = True
End If
End Sub
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks