#1
|
|||
|
|||
Use VBA to find all cells with the same value and add to list
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 |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
yep, thanks for that, a great start...
|
|
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 |