I'm not sure why you are doing this, can you explain? There might be a simpler way to do it. You could use Named Ranges for example.
I would start by using Data validation instead of the comboboxes
I'm not sure why you are doing this, can you explain? There might be a simpler way to do it. You could use Named Ranges for example.
I would start by using Data validation instead of the comboboxes
Last edited by royUK; 09-28-2008 at 01:10 PM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I used the pull downs because there wasn't any room in the cells, the cells below them had different data and I had to resize the column widths and row heights. The pulldowns were an after thought so they fit better.
My goal is to be able to copy from any sheet any section to any other sheet (many) and in any section. The good things are the sections are all the same amount of rows and columns.
After playing with code the last several months, I am starting to understand "real" code more and appreciate that.
I can actually write the code now with your guys help, but it would be alot of If pulldown 1 = ? and pulldown 2 = then. As you can see with 21 pages this could be alo ifs/then.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks