Forum Discussion

Copper Contributor

Feb 12, 2021

Solved

Self populating data sheets

Hi, I wondered if it is possible to populate a sheet dependent on cell values in another sheet. I hope the sample sheet I have designed is self explanatory. The answer if there is one would ...

Paul excel ordering query.xlsx13 KB

excel

Formulas and Functions

Macros and VBA

Riny_van_Eekelen
Feb 12, 2021
Paul_wfp Are you on MS365 with access to the FILTER function? If so, please see attached.
Paul excel ordering query.xlsx12 KB

Riny_van_Eekelen

Platinum Contributor

Feb 12, 2021

Paul_wfp Are you on MS365 with access to the FILTER function? If so, please see attached.

Paul excel ordering query.xlsx12 KB

Paul_wfp
Copper Contributor
Feb 12, 2021
Riny_van_EekelenTotally superb thank you so much.
- Riny_van_Eekelen
  Platinum Contributor
  Feb 12, 2021
  Paul_wfp Good to hear it worked!
  - Paul_wfp
    Copper Contributor
    Feb 12, 2021
    Riny_van_EekelenRiny I have applied it to my actual data and it is superb , such a powerful tool. I have also enjoyed trying to understand the formula.
    
    Many thanks again.
    
    Paul