Avatar of K B
K B
Flag for United States of America asked on

Create new Excel Worksheet from the common values of one Column.

I would like to take two worksheets (tabs) and create a new third tab.
The code would create the 3rd tab by matching on the common values in the column named "PrimarySmtpAddress".

I have attached a sample file. I saved it as an .xlsx but it can be renamed as a .csv obviously.
Note: the SamAccountName is typically a number at this company but it can also be alphanumeric.

The sample is only 20 rows of data however both tabs will actually have just under 400,000 rows of data when I use the code against it.

I have attached several screenshots and a sample file.

Thank you for your time in advance!

K.B.

Tab named "wSamAccountName"Tab named "wLastLogonTime"Example of desired results.EE-Sample-Combine-2Tabs-by-Common-Column
Microsoft ExcelVB ScriptVisual Basic.NET

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rob Henson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61