I have a spread sheet that will have new data entries on each row. I need to get excel to automatically check for a specific column's value, and if that value is a 1, it needs to go to the sheet with the same title as the column. See this below image for an example;
Example
So there are 6 columns I need this check done on, basically. OUT_O_10, OUT_10_20, and so on, you see in the image. If the column OUT_O_10 has a 1 on it in the first sheet, I need the row, columns A through H only, copied to the next available row on the sheet also titled OUT_0_10.
This link will let you download a near-perfect example of what I want to do. Just like this spread sheet can check the "Department" column and move the rows to the sheet that has the corresponding title, I need my spreadsheet to check each of the columns that has the word "OUT" in it for a value of 1, and if there is a 1, move the row (columns A through H only) to the sheet with the same "OUT" title.
Please let me know if this is not clear. There must be a way to do it automatically though, as this sheet does exactly what I need mine to do, just can't figure out how to do it myself on my sheet. I do have excel 2016.
Thank you!
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 298
تاريخ: پنجشنبه
30 ارديبهشت
1395 ساعت: 23:46