new to vb programming

[feather1000]

basically looking at "if" name in A4 is this then get data from worksheet #4 row b5 - b20 (b5:b20) and put that data into worksheet#1 at b5 - 20. there are to many variables to put into cell formula.

 

[feather1000]

works great ty very much for the help on this project .

question that remains is that if "sheet 1" has a break in a cell region could i put in something like this ?
Case "BANTRIDGE II": Range("C5:C20,c25:30").Value = Sheets("series 100a").Range("D5:D20,d25:d30").Value

if I can not then i'll remanulipate the worksheets to make it work as is

 

[VoG]

It would actually be

Range("C5:C20,C25:C30").Value = Sheets("series 100a").Range("D5:D20,D25:D30").Value