Hello and good afternoon.

I have a report that opens in a browser and there is no option to export directly into Excel. So I have to copy-paste data into an Excel...format and manipulate into what I need it to look like. Below is what it looks like (where I pasted it starting A2).

Sample below:

Sample.jpg


In this sheet, there will only be two scenarios where I will use the Filter function. One is to filter Col. A for <> OR Col. E for <>. When column A is filtered for <>, it basically shows only rows 2, 10 and 11. In this scenario, what I would like for the column headers to be is "Entity", "Partner", "GL" and "DR/(CR)" in cells A1, B1, C1 and D1 and since rows where A is <> does not have data in columns E and F, I want the column headers to be blank.

Now if (only) Column E is filtered for <>, then only rows 4 and 13 becomes visible, and what I want is Column Headers to change...where A1 is now blank, B1 is now "Entity", C1 = "Partner", D1 = "DR", E1 = "CR" and F1 = Difference.

Can this be done?

Thank you very much,
Storm