Copy data and paste it on range after filtering | Same workbook

[V834131]

Hi, 

There are 2 sheets on the same workbook file as shown below. 

Sheet name "Data" contains raw data.

Sheet name "Table" where the information will be pasted.

My goal is to paste the data to the cell range on Table sheet. On "Data" tab, filter header name Trading Member equals to "HK" and header name RiskType equals to "GROSS" then get the maximum value and percentage under header name Max Utilization and Max Utilization % respectively.  Afterwards, these max value and percentage will be pasted to cell L9 and M9 under "Data" tab wherein similar header is stated. 

I created a workflow however, it creates another sheet not directly inputting it on the desired cell range on Data tab. Note that apart from "GROSS", there are other RiskType to be filtered but I only built one for now. 

[KGT · Accepted solution]

Hi,

The workflow that you posted does not have the input file and hence I cannot run it. The steps look fine, however I can't see why the output would post to another sheet but I expect that it is in the way the range is referenced.

I believe that should be Table$L9:M9. The dollar sign is a reference separating the sheet name and range, not making "L" fixed. As you are outputting to a defined range, qualifying the cell range with "$" is redundant and probably causes errors.