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.)
I Created 2 Sheets.
Sheet1 contains (A1)S.no., (B1)Name, (C1)Sex, (D1)Date of bitrh, (E1)Age [E:E Contains Formula to find Age] and so on.
There are so many Datas (lines) in Sheet1.
In Sheet1, If Age is >5, the same list S.no., Name, Sex, Date of bitrh, Age,... and so on will be display one by one rows in Sheet2.
How to do it? ( Without FILTER Option )
In essence, your plan for Sheet2 is a filtered copy of Sheet1. Therefore the best way to do it is to apply a filter to the list in Sheet1. Just filter out all rows with DOB smaller than 5 years ago.
You should be encouraged to work with the filtered data, i.e. not to create a copy. However, if such is your need, Excel supports copying the filtered list to another location, for example, Sheet2.
If you need more help with this problem it is essential that you should create an post a workbook, with some sample data, on which a solution can be demonstrated.
