Finding cell values common to all worksheets

[phor89]

Hi all.

I have a workbook with several sheets within it. Each sheet contains separate stock information with Dates in column A and Prices in column B. In a summary sheet, I want to list all the dates that are common to every stock, so that I can then use a vlookup function to collect all the prices on those common dates.

Does anyone have a good solution for consolidating the common dates into Summary(A:A), using VBA?

E.g.

Sheet1:
A1:A3 = 19-Mar-21, 18-Mar-21, 17-Mar-21
Sheet2:
A1:A3 = 19-Mar-21, 17-Mar-21, 16-Mar-21

I would like the Summary sheet to display..
A1:A2 = 19-Mar-21, 17-Mar-21

I need a VBA method because there may be 20+ sheets to cycle through, and possibly thousands of rows of dates in each sheet.

Thanks

[dangelor]

Possibly...

Please Login or Register  to view this content.

Assumes all worksheets have dates in column A, and the summary worksheet is blank.