| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup source for Macro from a dynamic Range
Hi all
Hoping someone will be able to point me in the right direction. Am creating a spreadsheet that a records new client data and enters it on sheet 1,via a userform. From sheet 2 onwards are individual client acounts. Question 1 on userform2 i need to create a list box from the client info on sheet 1, as this is a dynamic range, i am not sure of the coding for this, is this possible? Question 2 On completion of data on form2, all data to be posted out to respective client accounts,not sure of the coding for this? Question 3 Is it possible that on entry of a new client, a new client accound sheet could be created? Many thanks in advance for any direction with this Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Source Data - Values - Dynamic Range possible? | Charts and Charting in Excel | |||
| Dynamic Range Name Macro | Excel Discussion (Misc queries) | |||
| xy scatter source from dynamic range | Charts and Charting in Excel | |||
| macro code to get dynamic range | Excel Discussion (Misc queries) | |||
| How do I create a dynamic range in a macro | Excel Worksheet Functions | |||
Threaded Mode
