Re: VBA to copy and move data based on multiple criteria to new sheet
Hello! I am currently using the macro solution above to extract data from a single workbook sheet to multiple sheets. It works great. I would like to alter it a bit so that I can specify columns to be extracted. For example, if columns A-Z are populated, I would like to extract specific columns: A-G, J, M, P-S, Z. Any assistance from the community is appreciated!
code is from this thread
https://www.mrexcel.com/forum/excel...riteria-new-sheet.html?highlight=FilterData()
Hello! I am currently using the macro solution above to extract data from a single workbook sheet to multiple sheets. It works great. I would like to alter it a bit so that I can specify columns to be extracted. For example, if columns A-Z are populated, I would like to extract specific columns: A-G, J, M, P-S, Z. Any assistance from the community is appreciated!
code is from this thread
https://www.mrexcel.com/forum/excel...riteria-new-sheet.html?highlight=FilterData()
Last edited by a moderator: