Hi all,

Quick question. I have a combo box i want to use to copy columns fro
one sheet to another. The criteria is:

704 - Copy column a sheet1 to column D sheet2
706 - Copy column b sheet1 to column D sheet2
708 - Copy column c sheet1 to column D sheet2
710 - Copy column d sheet1 to column D sheet2

704,706,etc is the fill range. Can someone please provide the code t
copy the columns if selected. Note also there is protection....

Thankn you all in advance!!

--
Message posted from http://www.ExcelForum.com

Hi Dave,

Thanks for your assistance. I got it to copy once but not again after
The selelctions i listed are the only ones and im not sure by what yo
mean whatever is in the combo box. Can you set up completely based o
the selections i hav given. Will protection of cells/sheet be
problem.

Thank you in advance Dave.

Cheers!!!!

--
Message posted from http://www.ExcelForum.com

Your combobox gets populated some way.

Since you didn't say where the combobox is (on a worksheet or a userform??) and
what it's named, I didn't know how to get that value.

maybe...
myVal = "706" 'whatever is in the combobox

becomes
myVal = worksheets("sheet1").combobox1.value



"gavmer <" wrote:

Hi Dave,

Thanks for your assistance. I got it to copy once but not again after.
The selelctions i listed are the only ones and im not sure by what you
mean whatever is in the combo box. Can you set up completely based on
the selections i hav given. Will protection of cells/sheet be a
problem.

Thank you in advance Dave.

Cheers!!!!!

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

Dave,

Mate, you are spot on. I can thank you enough for your help.

Cheers!!!

--
Message posted from http://www.ExcelForum.com