Dynamically Update List

  • Thread starter Thread starter Joe L
  • Start date Start date
J

Joe L

On Sheet1 I have a list 5 columns wide.
When a row is added to the list I would like to add a row to a list on
Sheet2. The third column on the Sheet1 list would drive the value in the
first column of the Sheet2 list.

Is this possible without VBA? I am avoiding VBA because I have to
distribute this to my clients and they will most likely have the default
security where all VBA is not allowed.
 
Joe
Look at VLOOKUP in help. You would have to put a VLOOKUP formula in
each cell in Sheet2 over the range you think will get populated. HTH
Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top