Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Short list

0

I need 1 option . How to do it i don't know. Please help.

I have 2 sheets.

First sheet contains some datas. In Cell A1 S.No, B1 Name, C1 Date of birth, D1 Age, E1 School name. And Assume A2 to E100 contains some datas.

I need all list one by one (rows) that contains age is equal to 5 in Sheet2.

Please don't suggest FILTETR Option.

Please help as soon as possible.

Thanks in AdvancešŸ™

excel
MS Office Version: 2016
posted by: brsapril1978 (rep: 8) on Tue Sep 15, 2020 at 9:55 am
Answer
Discuss

Answers

1

If I understand you correctly, just click in the data, go to the Data tab and click Filter and then click the arrow in the age column of your data and uncheckĀ Select All and check next to the number 5 for the age. Then copy the data that is filtered and paste it onto the other sheet.

Update

Since you are in Excel 2016, and so can't use the FILTER() function, check out the tutorial for Vlookup to Return All Matching Results and then just put that on the other worksheet and reference the sheet with the data.

This formula is not simple, but it should work to do what you need.

posted by: don (rep: 1989) on Tue Sep 15, 2020 at 4:04 pm
Discuss

Discussion

Thanks for your response. But i need data in another sheet automatically. And i know Filter Option. So any other optin .... please
brsapril1978 (rep: 8) Sep 16, '20 at 1:23 am
Answer updated! Let me know how it goes :)
don (rep: 1989) Sep 16, '20 at 2:12 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login