Copy from one named range to another

[Pauljj]

This should be simple, however my brain is not playing ball this week and I would like some advice please

I have a named range on one sheet and simply want(on the click of a button) to be able to copy this range to one of 7 named ranges on another sheet.

So for example when the user clicks the button it will copy range DUTY1 to a name range determined in T3. T3 has a day of the week (text) so if this says Sunday, I want everything in DUTY1 to paste over to range SUNDAY on the other sheet.

Would someone please mind helping ?

 

[jvanbonn]

Sounds to me you want to use an advanced filter.

"Data" tab on the ribbon bar
"Advanced" from the "Sort & Filter" group

 

[Pauljj]

Hi there I need to automate it, rather then a manual process

 

[Rick Rothstein]

If the named range SUNDAY points to a single cell (as does the named range DUTY1), then this VB statement should do what you want...

Range(Range("T3").Value).Value = Range("DUTY1").Value

 

[Pauljj]

This does sort of work but there are problems which are more down to my set up then your code, where I am pasting it to, the range is a wider area then what is being copied, ie, I am copying 4 columns and the range I am pasting it to is 10 columns, so basically I wanted to paste to the first 4 columns and the next part of my macro was to copy another range and paste it to the second to last 4 columns of that range. Ie leaving one blank column after each range. I now probably have you completely lost ...but I have used up so much of your time I am now conscious that I should just do this by selecting specific ranges, the coding will be longer but will still work.....and best of all, I should be able to work this out myself without bothering you