Automate Excel

5 Responses

1. ashley Says:
   June 23rd, 2005 at 8:15 am

   how do i unshare a workbook being used by 3 computers

2. Mark Says:
   June 23rd, 2005 at 9:13 am

   Tools->ShareWorkbook, then uncheck the “allow changes” button

   ???

3. jim Says:
   September 6th, 2005 at 6:01 pm

   How do I convert averaged figures to 2 decimal places??

4. Jack Says:
   November 20th, 2008 at 1:14 am

   I have a need to validate drop down lists. I have a list in column A - with 5 values. Now, depending on which value is chosen, I want to validate data in another column. Is that possible without writing a macro?

5. Soloman Crack-Hell Says:
   December 12th, 2008 at 12:03 am

   Hello Jack,
   I am not totally sure what you’re asking, however you could probably use either:
   a simple If statement,
   a “Vlookup”
   or even potentially a pivot table to do what you want.
   Hope that helps.

Leave a Comment