Is it possible that to use a keyword, "Done" for example, to then allow a button macro copy and paste that record to an existing tab?
Copy row to new sheet based on cell value
- dsmith616
- Thread is marked as Resolved.
-
-
-
Re: Copy row to new sheet based on cell value
Would you expand upon your question with an example of what your data is like and what you want to happen with the data. Please be as specific as possible.
-
Re: Copy row to new sheet based on cell value
Sorry for the delayed response I was traveling out of town. I've included a sample that hopefully makes sense.
On tab "CIT291", Column A, is a status column of the agents work. What I'd like to do is when the agent selects "Done" from either a drop down or manually types it (not sure if the coding will vary depending on method - either way is fine; easier route is acceptable) it'll copy that row over to the tab "CIT291_History". All other line items may stay on the original tab.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!