find copy paste loop multiple results

Hi,

So here is what I have "sheet 1" is an import sheet which imports data from a XLS folder which in turn is created from another program.

the import sheet can have 1 item or over 1000 items, which list down column "A"eg. see attached
Untitled.jpg

all other columns stagnate so the headings will never change. just the information in each cell may change

now because I have multiples of the same item but with different and same values what i think i need is a vba macro that can search for a few different things and at the end of that copy and paste the values on "sheet 2" (calcualtions sheet)

so for eg.

if column "A" = "clnm4000" and if column "B" = "110" then find all the matches for the first two arguments and copy all results that corresponds in column "C" to "sheet 2" from "A1" I hope that make sence.

but becuse my kwnolage of vba is extremly limmited i cant figure out how to loop this code that i found in a post below and copy all the matched results from column "C" to sheet2

Please Login or Register  to view this content.

thank you for any responce in advance
MTB1

Your jpg attachment will not help us much. Why not attach a sample "excel" file?

if column "A" = "clnm4000" and if column "B" = "110" then find all the matches for the first two arguments and copy all results that corresponds in column "C" to "sheet 2" from "A1" I hope that make sence.

So only columns A - C should be copied to Sheet2?

What are the other conditions to be checked? (Some users ask that i show them how to code one condition and they will do the rest, but i would say, atleast let me show you 2-3 conditions, because there could be a shorter way of doing it than just repeating the if condition.)