Hello!
This is my first post for excel help! I have a document that has a tab titled "Capital List" and then 10 other tabs titled "year 1" through "year 10". Column E is titled "need level" on every sheet. On the first sheet, a need level numerical value is going to be assigned from 1-10 for each item/row, and I need the entire row to be transferred automatically to the correct sheet. If the need level is "1", I need that whole row to be copied and pasted on the "year 1" page, and so on. I believe from my limited research that I might need to use a macro formula to achieve this, but i'm not sure. Can anyone help me solve this?? I have attached an example document I plan on using to this post. Please help if you can! Thanks,
Scott
Bookmarks