Getting Excel to Conditionally Copy Data to Another Sheet

خرید بک لینک

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

صفحه بندی