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

--
Message posted from http://www.ExcelForum.com

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.

--
Regards,
Tom Ogilvy


"fullymooned " wrote in message
...
I need to search for a certain asset number in the asset column in many
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 the
excel files have the same columns but different data.

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

thank you


---
Message posted from http://www.ExcelForum.com/