Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nangel
  • Content: Threads
  • Order by date
  1. nangel

    How to allow a user to modify a cell but do not delete it?

    I would like to allow a end user to update a excel spreadsheet by adding 1 to a cell. Please see the example below: Example On Monday the output was A B C D E F 1 t1 9 2 t2 7 3 4 ttl 16 5 On Tuesday a User opens the file and adds one to "1B". A B C D E...
  2. nangel

    How to update a cell by one only!

    I would like to allow end users to update some information but only to update the information by adding one at a time. Example On Monday the output was A B C D E F 1 t1 9 2 t2 7 3 4 ttl 16 5 On Tuesday a User opens the file but it needs to add one to "1B". I would like...
  3. nangel

    Deleting multiple ranges at once

    I would like to delete multiple ranges from multiple spreadsheets at once. Example: A workgroup has three Spreadsheets Sheet 1: delete the range from c4 to c53 and f4 to f53. Sheet 2: Delete the range from c62 to d84 Sheet 3: Delete the range from a11 to d3 and f2 to k70 I would like to...
  4. nangel

    How do I copy a cell to a "CELL+1" cell Every time a Button is press?

    I am automating a process using excel. I created a button to execute a couple of commands. What I would like to do is to copy a cell to the cell next to it every time the button is press. Example: A B C D E F 1 t1 10 2 t2 20 3 4 ttl 30 5 First time after you press the...

Part and Inventory Search