Copy entire column IF...

**LoooM** · 09-18-2013, 11:33 AM

Hey guys.. you always been incredibly helpful and kind.. so here I am!

I have a sheet with data from A3:A4 then B3:B5 then C3:C10 and so on for 30 columns..
On top of each column I have two numbers (in A1 I have "1" , in A2 I have "3".. in B1 I have "4", in B2 I have "9" and so on...)
I'd like to select from a dropdown menu a number between 1 and whatever (1500 for example..) and underneath the dropdown menu have the column of where the range falls..
EXAMPLE..
If I choose in the dropdown menu "2" It will copy all the cells A3:A4
If I choose in the dropdown menu "8" It will copy all the cells B3:B5

Hopefully I explained myself properly.. I looked around but I couldn't get to a solution..

Thanks a lot in advance!

Luca

**Pepe Le Mokko** · 09-18-2013, 12:34 PM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic