hope someone can help
breakdown its 3 worksheets that i want to pull data from 1 of those 3
what i need is
if c2>0
add contents of x2 from workbook 1 to cell aa7
b2 from workbook 2 to cell ab7
c2 from workbook 3 to cell ac7
if cell c2 equals 0 skip cell and check next cell
generate codes only entered in cells c2:c900
thanks if you can help
breakdown its 3 worksheets that i want to pull data from 1 of those 3
what i need is
if c2>0
add contents of x2 from workbook 1 to cell aa7
b2 from workbook 2 to cell ab7
c2 from workbook 3 to cell ac7
if cell c2 equals 0 skip cell and check next cell
generate codes only entered in cells c2:c900
thanks if you can help