I have a workbook to do some cool little tricks for me, including building text strings I need to paste into a status update database.
That database stores all data in caps, but I send emails out and such where I grab that data and don't want it in all caps.
I'd like to paste it into a cell on a worksheet, Cell G21.
I'd like it to then automatically copy the contents of Cell F21 and copy it to the clipboard.
I have another instance where I paste a phone number as 0000000000 and want to auto-convert to (000) 000-0000, which I am doing with another formula. I'd like to keep the formulas in the cells in case I want to use this for other formulas I create later.
1. Is it possible?
2. Can it be written to specific cell references so I can do it for a couple of other cells as well?
3. Can a worksheet change event apply to a specific cell?
4. I anyone feeling generous today? Generous enough to write that code for me? (No laughing). :eyebrows:
That database stores all data in caps, but I send emails out and such where I grab that data and don't want it in all caps.
I'd like to paste it into a cell on a worksheet, Cell G21.
I'd like it to then automatically copy the contents of Cell F21 and copy it to the clipboard.
I have another instance where I paste a phone number as 0000000000 and want to auto-convert to (000) 000-0000, which I am doing with another formula. I'd like to keep the formulas in the cells in case I want to use this for other formulas I create later.
1. Is it possible?
2. Can it be written to specific cell references so I can do it for a couple of other cells as well?
3. Can a worksheet change event apply to a specific cell?
4. I anyone feeling generous today? Generous enough to write that code for me? (No laughing). :eyebrows: