Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Noob needs help comparing columns and returning counts
StrongM your a legend!!!! Thanks so much. You saved me much headache. I really appreciate your assistance and the others who replied to this post and provided valuable information.- Leeman73
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Noob needs help comparing columns and returning counts
ok I have tried to simplify this now instead of opening and closing worksheets I have added the data to one worksheet. I think the KISS (Keep it simple stupid) applies to me here. I have 5 columns as shown below. I want to look in the first column (prdCde) and then look in the 4th column for...- Leeman73
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Noob needs help comparing columns and returning counts
I know this would be easy to do in Excel function but I wanted to try this in VBA.- Leeman73
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Noob needs help comparing columns and returning counts
I am new to vba and have thrown myself in the deep end. I am using excel and am atttempting to write some code in VBA I have two spreadsheets. The first spreadsheet has a column of ProductNames in them and they are all unique values, Variants. The second spreadsheet has 2 columns, the first...- Leeman73
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
