Copy filtered data to sheet 2

RSK - May 15, 2017 at 06:25 AM - Latest reply: TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen
- May 15, 2017 at 11:39 AM
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


See more 

1 reply

Reply to this topic
TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen - May 15, 2017 at 11:39 AM
0
Helpful
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
Respond to TrowaD