Auto populate multiple rows form different sheet with VBA

When a reference code is typed in on current sheet it auto populates a row from "Pricebook" sheet. If I wanted to make the reference code (Row A) populate 10 rows on my current sheet how could I code it? For example: I would want one code "XXXXX" typed in C21 to auto populate C21-C30 and AA21-AA30 row by row from the "Pricebook" sheet. On the "Pricebook" sheet the "XXXXX" reference code would be in cell A4 where I want it to pull rows 4-13.

Thank You,

Please Login or Register  to view this content.

Use the Resize property. If you mean you want to copy 10 rows from the Pricebook sheet to the other sheet, try this. If I have misunderstood, try removing the resizes on one side of the equals sign.

Please Login or Register  to view this content.