searching different files macro

  • Thread starter Thread starter fullymooned
  • Start date Start date
F

fullymooned

I need to search for a certain asset number in the asset column in man
different excel files. If the asset number does exist it should copy
paste the whole row into a new sheet and build on that sheet . all th
excel files have the same columns but different data.

i am looking for a macro or any other way to automate this

thank yo
 
Turn on the macro recorder and do an advanced filter on your data, selecting
the option to copy to another location.

Pick a location on the same sheet for simplicity.

Now turn off the macro recorder and look at the code. You can modify the
destination to be another sheet or another sheet in another workbook if you
want.

You can change the area to be filtered by using CurrentRegion as an example.
 
Back
Top