Forum Discussion

Olimpiu's avatar
Olimpiu
Copper Contributor
Apr 08, 2025
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 !

 

 

  • Olimpiu's avatar
    Olimpiu
    Apr 09, 2025

    It is working !

     How can I spread the formula in column B ? To "filter" the B column the same as A column ?

     

    Thank you !

Resources