Report

Copy filtered data to sheet 2

Ask a question RSK - Last answered on May 15, 2017 at 11:39 AM by TrowaD
Hello,
i have a main sheet with say column Item name and BATest.
i need to filter data of BATest and if Data is Analog input (for eg) then corresponding item name(Writable-AI) shouldbe written in some other sheet(Sheetname:2) in same workbook under pointName.
Please help on how to do that

Sheet 1:
ItemName BATest
Tenant_1 Accumulator
Writable-AI Analog Input
Writable-AO Analog Output
Writable-AV Analog Value
TLTest-AV1 Analog Value
TLTest-AV2 Analog Value
AnIn_New-average Averaging
Writable-BI Binary Input
Writable-BO Binary Output


Sheet2:
username pointName parameterName parameterValue
.\Administrator Writable-AI OutOfService 1


Helpful
+0
plus moins
Hi RSK,

On the Data ribbon you will find the filter option. Filter your data and copy the visible data to the second sheet.

Best regards,
Trowa
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!