Copy filtered data to sheet 2

Closed
RSK - Updated on May 15, 2017 at 11:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - 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


1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 15, 2017 at 11:39 AM
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
0