<div>
Do you really want to see the zeros?<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/05_w21/1164770/Cursor_and_Microsoft_Excel.jpg" target="_blank" title="00 (44 KB)"><img alt="00" class="file-block lazyload" style="max-width: 540px;" data-src="https://filedb.experts-exchange.com/incoming/2017/05_w21/1164770/Cursor_and_Microsoft_Excel.jpg" /></a>
</div>


Do you really want to see the zeros?
00https://filedb.experts-exchange.com/incoming/2017/05_w21/1164770/Cursor_and_Microsoft_Excel.jpg

Cursor_and_Microsoft_Excel.jpg

<div>
Martin not really <br />
here just to show an example <br />
you can do better !
</div>


Martin not really
here just to show an example
you can do better !

<div>
If you query two weeks, what should sheet &quot;COUNT P4 PAIRS&quot; look like?<br />
<br />
Should it have two columns?
</div>


If you query two weeks, what should sheet "COUNT P4 PAIRS" look like?

Should it have two columns?

<div>
one column for each date requesTed !!
</div>


Try this.
29025648.xlsm [https://filedb.experts-exchange.com/incoming/2017/05_w21/1164780/29025648.xlsm]

29025648.xlsm

<div>
I like it !!<br />
<br />
but where is the 4 numbers ??
</div>


I like it !!

but where is the 4 numbers ??

<div>
I used a different workbook as the basis for the code. I'm changing it now.
</div>


I used a different workbook as the basis for the code. I'm changing it now.

<div>
Great !! Thank you for thinking so .. Martin !!
</div>


Great !! Thank you for thinking so .. Martin !!

29025648a.xlsm

<div>
God bless you Always ! You're a Good Angel!<br />
Kisses!!
</div>


God bless you Always ! You're a Good Angel!
Kisses!!

<div>
<div class="content wysiwyg-content">
IN THSI CASE AN 4 NUMBERS &nbsp; HAVE 6 COLUMNS PAIR<br />
<br />
NEED SELECT SEVERAL DATES AND COUNT &nbsp;EACH PAIR<br />
EXAMPLE HERE ONE WEEK SELECTED &nbsp;1W2012 &nbsp; &nbsp; ONE SHEET FOR SELECTED NUMBERS<br />
ONE SHEET FOR COUNT &nbsp;PAIR &nbsp;19 IS 3TIMES COUNT<br />
<br />
Please Any Help !<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/05_w21/1164768/DTA4NUM.xlsx" target="_blank" class="file-inline" title="DTA4NUM.xlsx (72 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>DTA4NUM.xlsx</a>
</div>
</div>


DTA4NUM.xlsx

IN THSI CASE AN 4 NUMBERS   HAVE 6 COLUMNS PAIR

NEED SELECT SEVERAL DATES AND COUNT  EACH PAIR
EXAMPLE HERE ONE WEEK SELECTED  1W2012     ONE SHEET FOR SELECTED NUMBERS
ONE SHEET FOR COUNT  PAIR  19 IS 3TIMES COUNT

Please Any Help !

NEED TO COUNT THE PAIR

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.