Use VBA to find all cells with the same value and add to list

trevorc · #1 11-24-2021, 04:03 PM

Hi All,
Just starting to add some more code to my current project.
We have a repair tracking system that lists each repair instance by row.
I would like to be able to search the whole sheet to see if the same repair has been here previously and if so concatenate the text in each repair action field onto a repair sheet that we put with each repair.

The code below will find the currently selected entry only. I need it to find all other instances of the Ass_Num not the current row.

Just point me in the right direction please.

Code:

Ass_Num = Intersect(acrow, tblColumns("Asset Number").Range)
                With Sheets("Repair File").Range("F:F")
            Set c = .Find(What:=Ass_Num, LookIn:=xlFormulas, LookAt:=xlNext, MatchCase:=False)
            rrow = c.row
        End With

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
List of N last cells	beginner	Excel	3	06-17-2021 12:01 PM
First of all check to cells and after drop down list	DIMI	Excel Programming	2	11-27-2019 12:15 AM
what method to find all cells paste linked to a certain cell ?	DBenz	Excel	1	06-28-2018 12:16 PM
Excel-find cells that contain all upper cas	Mamadukes2007	Excel	2	02-06-2016 02:17 AM
Table will not allow sorting because "cells are merged". I can't find the merged cells.	wendyloooo	Word Tables	1	05-26-2015 01:19 PM