Forum Discussion
Bamhir2315
Feb 07, 2023Copper Contributor
Cutting rows from multiple worksheets and pasting in another based on cell value
Greeting, <span;>I have a workbook containing all of my coworker's actions but they stopped using it because everything is done manually, there is a worksheet named after every one of them and ano...
rzaneti
Feb 09, 2023Iron Contributor
Hi Bamhir2315 ,
I think that it may be a little long code, but let's do this together. I'm sharing with you an example in the attached file. This is not the complete solution, but solves part of the problem (maps all of the worksheets, copy the rows that contains "Done" in column R and paste into PU Complete first empty row.
Please, take a look on there and tell me your impressions. Also, make any adjustments to make the sample more close to your real context. If this sample is in the right path, I will keep working on that, based on your feedback.