Can someone help with this please?
I have a sheet with many prices (horizontal) and clients (vertical), i know, using excel online and office 365, i can use filter function, but the problem is that i have more than 2 collumns and i would like a way, after choosing the client, only appears the columns with data and ignore the others in blank.
I have an example file so you can see better what i am trying to explain.
Can someone help please? I am not looking for any VBA solutions, just formulas.
Are you using Google sheets?
I'll download in Excel, I think you will need VBA to hide completely empty columns.
I use, and prefer to use google sheets on my personal files.
BUT in this case is for work and i am looking for a solution in Excel (365 ou web version) with no VBA.
If you have a solution in gsheets, i can save it for later reference. But i will still need a solution in Excel.
Thanks in advance.
No to google sheets, I think you will need VBA. Google sheets can have macros but they are lengthy to write.
Why is the data split into multiple tables?
Also, your euro values are Text not Numeric, this will also cause problems