VBA, copy cell range to sheet based on dropdown

[jsmith2094]

HI,

I have a sheet where I can add content to cells A2:D2

In cell B2 I have a drop down data validation list with options: Offline , Online , calls. these options also have a sheet named the same

I want to be able to copy range A2:D2 to the sheet that the user selects on B2 dropdown

any ideas?

 

[Rtrip9]

So I need this same thing but I need it to keep going. I modified the code a little to fit but no matter what row I select it only copies the rob B2:I2. I need it to copy the row I'm working on to the correct sheet.

 

[mumps]

Hello and welcome to the Forum. Please start your own new thread with a detailed explanation of what you want to do referring to specific cells, rows, columns and sheets using a few examples form your data. If you think that this is useful, you can include a link to this thread in your post. It would also be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet.