Forum Discussion
Filter rows from 4 sheets based on column value
Hi there, I'm having a bit of trouble navigating my way around some formulas trying to get this to work and after a few hours have decided to come here seeking help. I have an excel file with ...
Peter, Thank you for your response.
I have 365 I believe but my Excel won't recognise VSTACK function! I'm on 16.64 macOS version of Excel if that gives any context at all. So that's made the above solution not work for me, even though it looks beautifully straightforward!
I think I'm just going to change what I'm doing, having no luck finding a reliable solution. Even if I could find a way to pull from each sheet separately, by referencing a cell which contains the individual sheet names, but I think my lack of skill was preventing me from doing that, too.
Anyways thank you for your suggestion, I'll return to this perhaps once I see VSTACK in my Excel!
So far VSTACK is only for Office Insiders (Beta and Preview channels).