Forum Discussion
Solved
Find cell / copy row in excel
Hello !
I tried to find a solution but is too difficult for me, so I ask for some help from experts.
I attached a demo file to make myself understood better.
In the file "MAIN" I have all the informations from wich I want to extract datas into another file.
For example : I want to copy in another file, all the rows that contains in the cell A1,A2,A3...A1000, the name "Barnsley"or anything I want to autocopy. The same... for info that ar in the columns B,C...R
In the "MAIN" file there are 5 rows that contains "Barnsley" in column A and I made copy paste for the 5 rows in the file "LAST". But I want to make it automatic.
In the file "LAST" in cell A1 I want to type Barnsley. Then,
all rows that contains "Barnsley" in the column A from file "MAIN" to be automatically copied in the "LAST" file.
The same for all the columns from A to R and rows from 1 to 1000.
It is possible ? Even with a macro code?
Thank you for your time !
It is working !
How can I spread the formula in column B ? To "filter" the B column the same as A column ?
Thank you !
I saw now that my Excel version is " 2010
Here is a version that should work in Excel 2010. Change the city in A1 to change the result.
It is working !
How can I spread the formula in column B ? To "filter" the B column the same as A column ?
Thank you !
See the attached version. It uses the FILTER function.
I think is a good solution, but my excel do not have the FILTER function. Maybe because is an older version. I've tested your file and is not working to me. I tried FILTER function looking at some tutorials and it not exist in my excel.
There is other solution ?
Thanks a lot !!
