Link to home
Start Free TrialLog in
Avatar of KP_SoCal
KP_SoCalFlag for United States of America

asked on

Slightly Modify Existing VBA Code

Please reference the attached file for this request.  In the "Results" tab when clicking the "Click to Run Code" button, you'll see data from the ZONE worksheets be appended the "Results" wkst.  

I have another tab that is highlighted in yellow called "Expected Results" that excludes the data that would populate the "People" column.  This should be a very slight modification.  I tried tweaking it with no luck.  I need an expert's advice on this one.  Thanks!
Append-Example2.xlsm
ASKER CERTIFIED SOLUTION
Avatar of harfang
harfang
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KP_SoCal

ASKER

Ok this fixed it, thank you.  Another question related to this macro...after running the code, column A in the "RESULT" tab is reflecting the the sheet tab name for each of the "Zone" sheets (e.g. ZONE US, ZONE CA, ZONE AU, ZONE BE).  Instead I would like only the last two characters of the sheet name to be reflected in column A of the results tab.  So instead of "ZONE US", it would be "US".

I'm sure a "right string" function would handle this nicely, but I'm not sure how to apply it to this macro.  Any suggestions?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Very nice, thank you!