Ask a question Report Reply to this topic

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

Excel Ask a question Report Reply to this topic

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

Copy filtered data to sheet 2
Auto-copy of select rows to another worksheet (Solved) » Forum - Excel
Copy filtered data from one sheet to another » Forum - Excel
Copy filtered data and paste values (Solved) » Forum - Office software
VBA for copying from data entry sheet to corresponding sheets (Solved) » Forum - Excel
Move completed data in sheet 2 » Forum - Excel

1 reply

Reply to this topic

Report Respond to TrowaD

TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen - May 15, 2017 at 11:39 AM

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

Reply to this topic

Ask a question