I’ve got a load of tasks in a spreadsheet laid out in rows, with associated data like ‘number’, ‘date’, ‘action’, ‘owner’ etc.
Some of these tasks require further work before they can be done, while others can just be done without further input. I have a column that expresses this with a Y for further work and N for no further work.
I want to set up another sheet that takes the rows where further work is required (Y in the cell) and duplicates the information, so I can see what needs further work in one sheet.
I don’t need all the data columns copying over though, just a few of them like ‘number’, ‘date’, ‘action’ and then I want to add a column to the end of this detailing what the further work is.
I could probably just filter for the Y’s and N’s (on the original sheet) but want to do it with a new sheet if possible, and if it’s not too tricky?
I did think about just doing =if(cell(A5)=Y,”A1″,””) and doing that for all cells in the row, but then I would end up with blank rows where there is an N. I’d prefer it if they ended up stacked beneath each other……
I really am crap at Excel!