Forum Discussion
Moving Rows Based on Information in a Cell
I am trying to create a Macro that when ran it will move certain rows depending on the value in the cells in a specific column. I have a spreadsheet that I need to split into two sheets depending upo...
Brittany0724 alternatively you can leave the original sheet and on the other 2 sheets just use the FILTER() function or a pivot table to populate that sheet with the corresponding data. If you need help doing that you could supply a sample workbook (no personal/confidential info) and we could show you more specific answer(s). but in general a FILTER() would look like:
=FILTER(Sheet1!A:M,Sheet1!A:A="only this id","None Found")where "only this id" would be a number or text that should be matched for that row to be included and A:A be changed to the column of interest.