• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

Excel Spreadsheet Sheet Comparison

We have an Excel spreadsheet with multiple sheets/tabs. On the first tab we have a full list of clients. Each of the following tabs represent individual months in which migrations will take place, and contain subsets of the clients contained on the first tab.

On the first tab containing the complete list of clients, we want to know which month, and consequently which secondary tab, they are on. On all tabs each client is identified by a unique ID number.

Is there a way to match the IDs on the main list and notate which other sheet(s) they appear on? We would obviously not want to manually go through all the data, so if there's an at least semi-more automated way to complete this, it would be appreciated.

2 Solutions
Hi there,

First thing that comes to my mind is VLOOKUP or  INDEX function depending on the criteria you are wanting to incorporate and layout of referenced sheets.
Uploading a test workbook with dummy data will help us immensely to get to a solution for you RdRacer :)

Saqib Husain, SyedEngineerCommented:
Try this macro. I did not test it as I had no data in hand.
Sub listmonths()
Set fws = ActiveWorkbook.Sheets("sheet1")  '<--------Name of first worksheet
For Each cel In fws.Range("A:A").Cells '<--------column which contains the IDs on first sheet
    For Each ws In ActiveWorkbook.Sheets
        If fws.Name <> ws.Name Then
            If Not IsEmpty(cel.Value) Then
                If Not (ws.Range("A:A").Find(cel.Value)) Is Nothing Then '<--------column which contains the IDs on secondary sheets
                    cel.Offset(0, 2) = ws.Name '<-----results to be inserted two columns from the ID
                End If
            End If
        End If
    Next ws
Next cel
End Sub

Open in new window

try this
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now