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...
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...
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...
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...