Hi Everyone,
I have two small problems that I can't figure out. Pls, help!!!!
1) Can I get Excel to automatically assign numbers when data is entered
into a specific cell?
2) Can I get Excel to automatically enter specific text (TR) when
information is entered into another cell?
Any help would be appreciated.
EXAMPLE:
A B C
24 Data Data
25 Data Data
26 Data X
When they put data where the X is I would like to next # to pop up under #26 in col. A
On a seperate sheet I would like the letters TR to pop up after data is entered in the previous row in col C.I hope I am not confusing you further.
Either way thanks for trying to help.
I have two small problems that I can't figure out. Pls, help!!!!
1) Can I get Excel to automatically assign numbers when data is entered
into a specific cell?
2) Can I get Excel to automatically enter specific text (TR) when
information is entered into another cell?
Any help would be appreciated.
EXAMPLE:
A B C
24 Data Data
25 Data Data
26 Data X
When they put data where the X is I would like to next # to pop up under #26 in col. A
On a seperate sheet I would like the letters TR to pop up after data is entered in the previous row in col C.I hope I am not confusing you further.
Either way thanks for trying to help.