Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find repeated values in multiple worksheets and create summary worksheet
Hi
I have an workbook that has 31 identical worksheets which each worksheet refer to one day of the month. every day my helpers enters some information in thoes pages. I am looking for help to create VBA code that will help me to search my workbook (the 31 Pages) and find the client numbers in the range B4:B37 that has been repeated, And create a summary sheet that will show the client number that has been repeated, how many times ithas been repeated and what was the first date that this client number has been entered. and if it possible to highlight the thoes client numbers in each worksheet that they have been repeated. Thank you for any help in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find repeated values in multiple worksheets and create summary wor
I responded to this request yesterday. Did you try that?
" wrote: Hi I have an workbook that has 31 identical worksheets which each worksheet refer to one day of the month. every day my helpers enters some information in thoes pages. I am looking for help to create VBA code that will help me to search my workbook (the 31 Pages) and find the client numbers in the range B4:B37 that has been repeated, And create a summary sheet that will show the client number that has been repeated, how many times ithas been repeated and what was the first date that this client number has been entered. and if it possible to highlight the thoes client numbers in each worksheet that they have been repeated. Thank you for any help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Cell from Multiple Worksheets to a Summary Worksheet | Excel Worksheet Functions | |||
Need help using data from multiple worksheets to create a Summary | Excel Discussion (Misc queries) | |||
Copying Cells From Multiple Worksheets to Create Summary Sheet | Excel Discussion (Misc queries) | |||
Find multiple repeated values in a Pivot Table | Excel Worksheet Functions | |||
Summary worksheet referencing multiple worksheets | Excel Worksheet Functions |