is this even possible? if blank cells, skip rows as well

August 25, 2016 at 16:33:31
Specs: Windows 64
Ok, so i work from home taking tech calls for Internet troubleshooting.
I have to have notes for every call that look something like:

ACCT Name:
Speaking with:
Call back number:
Troubleshooting steps:
Router Model:
Router Lights:
TKT Number:
TKT Date:
TKT Time:
Approved by:

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.

See More: is this even possible? if blank cells, skip rows as well

Reply ↓  Report •

August 25, 2016 at 20:07:02
Please read the instructions found in the following link and then post the Notes macro. It may just need some modificatIon.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Reply ↓  Report •
Related Solutions

Ask Question