Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
First time user
I have a sheet with multiple range names (range1, range2, range3, etc). I would like to have a list box with the range names in that list. If the user selects range2, then that range is the one that I would like to copy to a predetermined range on sheet 2. The range sizes are the same. Also, if they make a mistake, and select the wrong range, I would like for them to be able to reselect the appropriate range. I can get this to work with a macro where I enter the "from" range. I would like to automate that with the list box or something like that. Anything with the names already predefined so user can't enter an incorrect range name. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. | Excel Worksheet Functions | |||
Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
help with copying multiple ranges and paste it on a work sheet based on conditions | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions |