Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2021, 04:03 PM
trevorc trevorc is offline Use VBA to find all cells with the same value and add to list Windows 7 32bit Use VBA to find all cells with the same value and add to list Office 2013
Competent Performer
Use VBA to find all cells with the same value and add to list
 
Join Date: Jan 2017
Posts: 165
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default 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
Reply With Quote
  #2  
Old 11-24-2021, 06:38 PM
NoSparks NoSparks is offline Use VBA to find all cells with the same value and add to list Windows 10 Use VBA to find all cells with the same value and add to list Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 814
NoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the rough
Default

Quote:
Just point me in the right direction please.
A wealth of information on this page
Reply With Quote
  #3  
Old 11-24-2021, 06:51 PM
trevorc trevorc is offline Use VBA to find all cells with the same value and add to list Windows 7 32bit Use VBA to find all cells with the same value and add to list Office 2013
Competent Performer
Use VBA to find all cells with the same value and add to list
 
Join Date: Jan 2017
Posts: 165
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

yep, thanks for that, a great start...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use VBA to find all cells with the same value and add to list 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
Use VBA to find all cells with the same value and add to list Excel-find cells that contain all upper cas Mamadukes2007 Excel 2 02-06-2016 02:17 AM
Use VBA to find all cells with the same value and add to list 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft