Input Values to another sheet (from a specific criteria)

[Jenina]

Hi All - I would like to input the other fees amount from 100 Variance section to another sheet, how can I input the "100 Variance" criteria because the raw files are not fixed. Thanks!

[cjaneczko]

Do you want them in the same workbook as the source file? You can Use that workbook as the source of the input tool. Lets say its on Sheet1. Then create a workflow that filters on the GL AU column. 

[GL AU] contains '100 Variance'

This  will pass only the 100 Variance through the workflow. If you want to sum all of the 100 Variances you can add a Summarize tool. At the end of the workflow you will add an output back to the original workbook. From there you can have the data put on Sheet2 or whatever sheet you want in the workbook. 

[Jenina]

Yup same workbook, sheet1 to sheet2, do you have a sample workflow for that? The workflow I created is not working. 

[binuacs]

@Jenina One way of doing this

[Jenina]

@binuacs Thanks for this. I wanted to get the values under fees column based on the '100 Variance' cell then input to sheet2.  Is that possible? Thanks 

[binuacs]

@Jenina If you replace the input file in the given workflow you will get the result in Sheet 2. Add a select tool just before the output tool and select the fields you want in the sheet 2

[Jenina]

@binuacs  Tried it, for some reason the workflow is off somewhere.

[binuacs · Accepted solution]

@Jenina you should select the FullPath variable in the output tool instead of the filename field. I updated the workflow and it is working fine

[Jenina]

@binuacs Great thanks!