Forum Discussion

Copper Contributor

Jan 25, 2024

I need to pull data from a range into another sheet where the value in one column is repeated

I have a workbook with a sheet that contains 100,000 plus rows. I need to pull data from that sheet into another sheet where the value in column E is repeated more than once and column B contains TSC...

excel

Formulas and Functions

myester

Copper Contributor

Jan 27, 2024

peiyezhu Thank you! This does exactly what I need. I had to use ChatGPT to understand exactly what the VBA was doing as I'm not that familiar with it. I learned something new so thank you for that.

peiyezhu

Bronze Contributor

Jan 27, 2024

good.
My pleasure.