Excel: Replacing a Range with another Range

Closed
dragon2300
Posts
8
Registration date
Wednesday July 11, 2012
Status
Member
Last seen
September 5, 2012
- Aug 5, 2012 at 11:00 AM
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
- Aug 16, 2012 at 01:37 AM
Hello,

I am trying to create a drop down menu with 12 options in it that will replace a range of data with another range of data based on what you select.

E.g.

If c1 = day 1 then:
Range(B1:B165) = Range('BudgetImport'!B1:B165)

I can make the menu, as well as the repeating If statements, the problem is, i am having trouble replacing the data in B1:B165 with the dats from BudgetImport B1:B165.

Any help would be appreciated.

Thank you in Advance
Drake


1 reply

RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Aug 16, 2012 at 01:37 AM
Please explain your problem like what you required when c1 = day 2 or else.
0