Need help for copy file from data base with criteria

[k_2]

Hello , i have database where are some data for several shops i need macro which will copy data for exactly that shop which i will choose in summary sheet, for better understanding i also attached excel file.

[Insignificant]

Hello , i have database where are some data for several shops i need macro which will copy data for exactly that shop which i will choose in summary sheet, for better understanding i also attached excel file.

Found this on a previous thread I was looking at. Think it will help with what you are trying to do.

The person who posted it is watersev, join date 2010-29-11, Location: Ukraine.

a excel file was posted with the following instructions

"please check attachment, run code "test", enter value from column B."

TestData(1).xls

I TAKE NO CREDIT FOR THIS ANSWER. I also attach the thread URL for the thread I found this on

http://www.excelforum.com/excel-prog...ell-value.html