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
Microsoft ExcelSpreadsheetsMicrosoft Office

Avatar of undefined
Last Comment
KP_SoCal

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
harfang

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
KP_SoCal

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
harfang

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
KP_SoCal

Very nice, thank you!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23