Excel: Replacing a Range with another Range

Closed
dragon2300 Posts 8 Registration date Wednesday 11 July 2012 Status Member Last seen 5 September 2012 - 5 Aug 2012 à 11:00
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 16 Aug 2012 à 01:37
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


Related:

1 response

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