Gabe2k2
03-08-2023, 04:58 PM
So I confess I`m pretty useless in Excell and know of some of its potential and want to learn so My first task I want to ask about is lets say I have a Column A filled with numerical values entitled Codes and I want to Write a vba so each time I enter a new code that is the same as a pre existing Code/number it adds it to a total Column B
does this make sence.
some thing like
Codes total
1 ,,,,,,,2
2 ,,,,,,,2
3 ,,,,,,,1
4 ,,,,,,,1
5 ,,,,,,,1
1
2
7,,,,,,,1
8,,,,,,,1
9,,,,,,,1
even Better would be for it to delete the cells in column A or Highlight the duplicates but I dont want to see a total beside the duplicates
I think I Need to work with the =COUNTIF($A$2:$A$"total number of entries I dont know how to call this ",A3) then create a new column with new cells for totals =Unique(A2:"total entries call ") but so far I havent been able to achieve what I want also the number of entries in column A will change rapidly 1 every few seconds or less I just want to total up and list the unique entries in column A automatically
I`m using it to make a simple Spreadsheet for column A will be filled with barcode numbers and I just want to total how many items I scan that are the same in column B
Its for work and this would take some of the tedium out of manually counting each item
does this make sence.
some thing like
Codes total
1 ,,,,,,,2
2 ,,,,,,,2
3 ,,,,,,,1
4 ,,,,,,,1
5 ,,,,,,,1
1
2
7,,,,,,,1
8,,,,,,,1
9,,,,,,,1
even Better would be for it to delete the cells in column A or Highlight the duplicates but I dont want to see a total beside the duplicates
I think I Need to work with the =COUNTIF($A$2:$A$"total number of entries I dont know how to call this ",A3) then create a new column with new cells for totals =Unique(A2:"total entries call ") but so far I havent been able to achieve what I want also the number of entries in column A will change rapidly 1 every few seconds or less I just want to total up and list the unique entries in column A automatically
I`m using it to make a simple Spreadsheet for column A will be filled with barcode numbers and I just want to total how many items I scan that are the same in column B
Its for work and this would take some of the tedium out of manually counting each item