I need to count all blocks with the date and time in it as a unit in a block .F3 sheet Donnie and keep it up to count.
This is what i have at the moment but need to add on it.
I have two sheets , in sheet Donnie block A1 you scan a barcode , then it writes the Barcode in A1 sheet DDATA(2nd sheet) and the date and time in sheet DDATA (2nd sheet) in block B1 and if you scan in A1(sheet Donnie)same barcode again, it places another date and time in sheet DDATA block C1 and so on , next D1 if it the same barcode. If it is a other barcode it place the Barcode in A2 and the date and time in B1 .This is wat i want, that is fine.
I now want to count all the date and time blocks for that Barcode row as units in Sheet Donnie F3 and keep it counting as new scan happens. ?
Sheet Donnie
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 115"]
<tbody>[TR]
[TD="class: xl63, width: 115"]Barcode no[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136"]Serl. no.[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 208"]
<tbody>[TR]
[TD="class: xl67, width: 208"]Item Name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]Units[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD="class: xl65, width: 112"]Price[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 459"]
<tbody>[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]BWStock00001[/TD]
[TD]Stick lights[/TD]
[TD]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][TABLE="width: 102"]
<tbody>[TR]
[TD="class: xl65, width: 136"]BWStock00005[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 459"]
<tbody>[TR]
[TD]Removable red fridge hinges[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet DDATA
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]BWStock00001[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/03/2019 05:43:43 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/04/2019 02:03:45 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 155, align: right"]03/10/2019 09:35:55 AM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 104, align: right"]BWStock00005[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/03/2019 05:46:07 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/03/2019 05:46:44 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So in sheet Donnie block F3 it should count the dates as a unit 3 ?
and in Donnie block F4 should count 2 units ?
Please help?
Thank You
Gideon
This is what i have at the moment but need to add on it.
I have two sheets , in sheet Donnie block A1 you scan a barcode , then it writes the Barcode in A1 sheet DDATA(2nd sheet) and the date and time in sheet DDATA (2nd sheet) in block B1 and if you scan in A1(sheet Donnie)same barcode again, it places another date and time in sheet DDATA block C1 and so on , next D1 if it the same barcode. If it is a other barcode it place the Barcode in A2 and the date and time in B1 .This is wat i want, that is fine.
I now want to count all the date and time blocks for that Barcode row as units in Sheet Donnie F3 and keep it counting as new scan happens. ?
Sheet Donnie
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 115"]
<tbody>[TR]
[TD="class: xl63, width: 115"]Barcode no[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136"]Serl. no.[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 208"]
<tbody>[TR]
[TD="class: xl67, width: 208"]Item Name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]Units[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD="class: xl65, width: 112"]Price[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 459"]
<tbody>[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]BWStock00001[/TD]
[TD]Stick lights[/TD]
[TD]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][TABLE="width: 102"]
<tbody>[TR]
[TD="class: xl65, width: 136"]BWStock00005[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 459"]
<tbody>[TR]
[TD]Removable red fridge hinges[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet DDATA
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]BWStock00001[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/03/2019 05:43:43 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/04/2019 02:03:45 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 155, align: right"]03/10/2019 09:35:55 AM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 104, align: right"]BWStock00005[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/03/2019 05:46:07 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/03/2019 05:46:44 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So in sheet Donnie block F3 it should count the dates as a unit 3 ?
and in Donnie block F4 should count 2 units ?
Please help?
Thank You
Gideon