Hi,
I am trying to create a workbook that dynamically filters positive values and moves the categories and values up the sheet to ensure that there are no gaps where there is no data present. The report will be looking up to external data so I can't just use a standard filter. An example of what I would like to achieve is attached, giving 3 examples (there would only be one set of data per report, the 3 are just to show different examples) you can see the raw data in columns A & B and what I would like to output in D & E. If it can be done just in formulas, that would be great, but if it needs to be a VBA project, that is ok too. FYI - this will be used for multiple customers from the same workbook
Is this possible, please?
I am trying to create a workbook that dynamically filters positive values and moves the categories and values up the sheet to ensure that there are no gaps where there is no data present. The report will be looking up to external data so I can't just use a standard filter. An example of what I would like to achieve is attached, giving 3 examples (there would only be one set of data per report, the 3 are just to show different examples) you can see the raw data in columns A & B and what I would like to output in D & E. If it can be done just in formulas, that would be great, but if it needs to be a VBA project, that is ok too. FYI - this will be used for multiple customers from the same workbook
Is this possible, please?