|Ok, so i work from home taking tech calls for Internet troubleshooting. |
I have to have notes for every call that look something like:
Call back number:
etc. then i fill out what needs to be filled out.
i have an excel document that has all that info on column A then i fill out the info on column b
I have some Macro buttons such as "GET ACCT" "GET CALL BACK #" "NOTES"
if i press the "GET CALL BACK #" i have it setup to highlight and copy the call back number. This makes it easy to call customer back right away.
I have the "NOTES" button setup to highlight and copy ALL Cells and COPY
But depending on the call i might not need some cells.
Is there a way to tell a macro in "NOTES" to highlight cells A1-B10 (as an example) but specify if CELL B9 is blank to NOT Copy A9-B9 ?
if it makes it easier i can upload the spreadsheet to better understand.