Reesey
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 2 articles for 0.303 sec
pmms Wrote: > I'm creating a form that will be used for data entry and one cell is > the > product of 2 other cells. If the user needs to insert more lines the > formula > does not carry forward. Any suggestions? Thanks! I would create a macro (using the macro recorder - that's easiest) that copies and inserts a line with the formulas in it. Then I would add the macro to the toolbar     

Group: microsoft.public.excel.misc · Group Profile · Search for Reesey in microsoft.public.excel.misc
Author: Reesey
Date: Jul 25, 2006 13:29

I'm trying to figure out a simple, end-user friendly (for end users who don't use spreadsheets frequently) way of accessing sets of data. My thought was to name ranges of data, then create a drop-down list on the main retrieve sheet where the end user can pick from the list of names which would then automatically populate the retrieve sheet. I cannot think of a way of doing this (other than
Show full article (0.82Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for Reesey in microsoft.public.excel.misc
Author: Reesey
Date: Jul 25, 2006 12:16

Show full article (0.88Kb)