selection based on time stamp

ahmimas

New Member
Joined
Dec 19, 2020
Messages
14
Office Version
  1. 2016
Platform
  1. Windows
Hello,
I wrote a VBA excel program for tag printing with a thermal printer.
the program will store all the information printed in a spreadsheet called product_all, it will add the data at the end (first empty row).
in the last column, I save on every row, the date and the time when this tag was printed.
example:
code1 data1 data2 data3 12/11/2020 10:20:16
code2 data1 data2 data3 12/11/2020 10:25:30

and so on.
from this report_all, I would like to generate another report based on the date, so when the operator requests a report, he will get a message asking from-to what date, and the report will be generated based on that.
also, if it is possible to have a kind of calendar displayed so he can make a selection instead of typing the date.
the generated report will have the information of the starting and ending dates and times.
it will be also more convenient if in the generated report groups all the items that have the same code (the first column).
example:
production report> from: to:
code1 data1 data2 data3 5
code2 data1 data2 data3 3
and so on.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,213,494
Messages
6,113,981
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top