Auto Populate Sheet 2 basis data on Sheet 1

[Closed]
Report
Posts
1
Registration date
Tuesday November 26, 2013
Status
Member
Last seen
November 26, 2013
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
Hi
I have raw data on sheet 1 one of the column is "group name". Data is related to 150 groups, however I need data for only 24 groups. Is it possible to have this data for 24 groups automatically populate on next sheet the moment I paste raw data on the first sheet. Any solution is highly appreciated. The idea is to filter 24 groups out of these 150 with minimal efforts rather than having to select 24 manually which is time consuming.

Warm regards
Abraham.

1 reply

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
482
Hi Abraham,

What separates the 24 from the 150? What makes them unique; stand out from the others?

Copy (or move?) 24 cells or 24 rows?

Please provide any details that might help solving your query.

Best regards,
Trowa