Forum Discussion
Auto Fill columns based on filled cells to the left
Quickly, I hope I got it right through the translation.
Please open the inserted worksheet.
If you liked my solution, please mark it as the correct answer ... if possible with a like (Thumbs up 🙂
so that everyone else can be informed. If you didn't like my answer, please give me a quick feedback.
Thank you
Nikolino
I know I don't know anything (Socrates)
The numbers in column 3 are still filling to match the cells in column D. I want them to only go down as far as column B, but I still want to have the formula in column D down to the bottom of the page. I know that if I put the formula in column D only to the rows filled in columns A - C it works, but I want to be able to have the formula fill to the bottom of the column without the price auto-filling to that same row.
According to the translation it should be like this ... if not please report again and if possible show more specifically with the worksheet ... since my english is not the best.
thank you
Nikolino
I know I don't know anything (Socrates)- in cell D1 write:
=IF(B1<>"",B1*C1,"")
then autofill
