Excel: Replacing a Range with another Range [Closed]

Report
Posts
8
Registration date
Wednesday July 11, 2012
Status
Member
Last seen
September 5, 2012
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
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

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
118
Please explain your problem like what you required when c1 = day 2 or else.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!