Forum Discussion
Trying to create a formula to autofill cells (with text and other cells with dates)
Hi,
I'm trying to create a formula that will pick up only a few words in columns D, J or P. So if those words are in a in cell in those columns, automatically the cell containing those words needs to be copied in a cell in column V. So for example, if we take the words "Receipt for initial PD" in cell D2 needs to be copied to V2. Also, the dates in D3 needs to go to V3 but minus 3 days for approval.
Is it something that would be possible?
Can someone help me please?
Thank you very much,
Julien M.
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?
17 Replies
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.
Thank you Riny! This is very helpful!
