Return DATA from different sheet to multiple cells based on content of one cell

Try this

Please Login or Register  to view this content.

Kind regards
Leo

Thanks! I changed Sheet 2 to Sheet 12, to reflect the actual sheet in my workbook. When I run it I get a "Subscript out of range" error and the debug stops on the "With Sheets ("Sheet12")" line.

Sure the name of sheet is Sheet12 ?

if name is correct it works

Kind regards
Leo

This is the actual document. When I type in a new number, I get the error.

Nevermind, I see what I was doing wrong. Thanks so much!!!!

yes yes different between sheet name and sheet index

so if case is solved, can you mark as solved ?

thanks
Leo

Yes, I'll mark it solve. Care to decode what the Index( , 3) etc. means? I assume that they refer to cells. Just so I understand for the future.

i have no index (,3)
i have used target.offset(,3) and this refers to 3 cells right from target cell
so if target cell = A1 then Target.offset(,3) = cell D1 and target.offset(2,2) =cell C3 in this short exemple

Kind regards
Leo

Yes, my apologies. I meant target.offset. Thanks for the explanation. It really is a different language!

Ciao