Forum Discussion
Trying to create a formula to autofill cells (with text and other cells with dates)
Good morning! I attach two versions of your file with updated formulae in columns Y and Z in the Master sheet. One file is using the new FILTER function. It does exactly what you want, but it depends on your Excel version if you can use it or not.
The other is using a formula, similar to what you already had, but I couldn't figure out how to skip the empty rows. I know it's possible, I have seen it done but I can't find it right now. I believe it was SergeiBaklan who demonstrated it not too long ago.
But, after studying your file I wonder is you really need to skip the empty rows. You are using a template that seems be a Homework Tracker, producing a weekly calendar view of all tasks due on every day of the week. I noticed that, even with the empty rows in column Y, and Z the calendar view is correctly populated. So, why bother filtering out empty rows in the master list?
Attaching a simplified example of what I think you are asking for. Of course, you need to adjust it to the ranges in your own spreadsheet.
Do you know if it is possible to copy the cell in the next available cell? It does have to be A2 copied to F2.
I have attached a copy of my Excel. For example from my excel, If I want D11 to be copied, I want it to go in the Y column but to the next available cell. not to Y11.
Thanks!
I believe your Excel version requires the formula to be entered by Shift-Ctrl-Enter. It will put curly brackets around the formula. See attached.
Again this is very helpful! Thanks for all your help.
Although, I this is not exactly What I need. I think I am not explaining it the right way and I seems to be complicated.
I would like to have every cells that contains the words Receipt of initial PD be copied in the column Y but with the wording that every cell have. E.G. the first one starts with Alexandra, second one starts with Castle Mountain and the Hays LNG..... Those cells to be copied in column Y but in order starting from cell 2,3,4,5,6,7,8..... not like 2, 12, 34, 50.....
Have been away. Let me get back you tomorrow morning (CET).