using functions with macros

  • Thread starter Thread starter userofexcel
  • Start date Start date
U

userofexcel

I'm using Excel XP and need to set up a form for data
entry with the following specs.
I have three spreadsheets with different lists of info.
I would like to be able to enter a code in one column
that when either one of these lists are chosen, then the
drop down list becomes available for that list in another
column. Currently, I have drop downs for the code
column, and the three other columns for the lists. I
would like to have the cursor go to the specific column
associated with the code for that list. Can you stack
functions using the wizard? Or, can you use a macro in
the column with a function that would move the cursor to
the correct column?
 
Thanks Frank, Unfortunately, I don't have access to any
websites other than Microsoft. Do you know of any
resource to help that would be available via Microsoft's
web pages?
 
Back
Top