Forum Discussion
Cleaning Data Automatically in Excel
Hello, I am working on a project in excel and I need help to automate a few steps. I am trying to build something in excel that will automatically copy different cells in one sheet and paste it in an...
Tables in both your sheets are returned by PowerQuery, why don't clean the data directly in it? That will be easier.
I only didn't catch the logic. First sheet is that Sheet0 or Sheet1? Yes and No are in many columns, which one to use? "If no, then the program should move to the next row" but you have No in some columns for both sheets.
- I realize that it was confusing and difficult to catch the logic. I apologize for that and I thank you for trying to help. I posted a new discussion that explains my task a little better. If you would like to take a look at it, I'd greatly appreciate it. Thank you and have a great day!
If you mean this https://techcommunity.microsoft.com/t5/excel/vba-code-to-copy-certain-data/m-p/3577828 one it looks bit differently. Sorry, VBA is not my territory.
