Forum Discussion
Solved
How do I automatically fill columns based on a cell value from the same workbook.
When doing quotations I make use of standards (Std No.) where the different standards have their own BOMS (BOMS = Bill Of Materials) When I enter a standard number (Std No.) in cell F7 (in this case ...
- Riny, I realise my mistake. a Bit of language misinterpretation. I have simply copied the formula and paste it in cell G7 and not copying it down. Thank you for your help and the attached file.
Good day Riny, thank you for the response.
I first copy and paste the formula but with no success. Then I typed the formula in also without any success. It does not auto-populate column G. In both cases when I look at the results in the formula (fx) it correctly displays the column result. Even if I change the std no. in cell F7 the results are correct. Is there something I am doing wrong?
JanGreyling Well, I can't tell what's wrong if you don't show what you've done. Anyhow, I have attached your file with the working formulae in it. The INDEX formulae in G8:G20 and the FILTER one in AA8.
- Riny, I realise my mistake. a Bit of language misinterpretation. I have simply copied the formula and paste it in cell G7 and not copying it down. Thank you for your help and the attached file.
