Hi EE
I have a spreadsheet with, say, 5 columns with dozens of rows of data,
I want to show specific columns of certain rows of data based on values in one of the columns. I want to avoid doing this using a macro.
Rumour has it that I can do this using SQL but I'm a novice on that option.
I don't suppose anyone is willing/able to help?
Thanks
Ben
Have you looked at the "Autofilter" &/or "Advanced Filter" feature available from the "Data" menu of MS-Excel?
Please see: "Filter a range of data"
[ https://support.office.com/en-ca/article/Filter-a-range-of-data-057936b7-010a-4353-ae68-320a9c60b093 ]
If you would like to provide a sample workbook attached to this question thread, removing any sensitive information in advance, then indicate what you wish to filter upon, this may help the provision of suggestions/further assistance.