Copy filtered data to sheet 2

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

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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