My goal is a function/macro/script that automatically inserts a text in every selected cell by a key combination (or similar). The inserted text needs to stand at the beginning as seen in the example below.
Cells A1,A2,A3.....,A10
A1: open
A2: open
A3: Closed
A4: open 5. August
A5: Closed
A6: Closed
A7: open 8. April
A8: open
A9: open 14. April
A10: Closed
I would like to select cells A3-A7 and then use a keyboard shortcut (or similar) to supplement the contents of the cells with date and shortname (in this case: 17.11.20 hl). This will then result in:
Cells A1,A2,A3.....,A10
A1: open
A2: open
A3: 17.11.20 hl Closed
A4: 17.11.20 hl open 5. August
A5: 17.11.20 hl Closed
A6: 17.11.20 hl Closed
A7: 17.11.20 hl open 8. April
A8: open
A9: open 14. April
A10: Closed
I appreaciate any help. Thanks a lot.
Best Luca