Curious if this is possible in any way with Excel

A Welcome to the forum.

It will make it easier to help you if you include an Excel workbook. (not a picture of a workbook please)

Directions:

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Ah sorry! I thought the numbers would align as in the editor

Anyways I added an example.

I used just filled out a few numbers for an example.
The first tab is the invoice, which is quite obvious.
The second is the one we use in our Store with a Tablet, the amount ordered is filled out here.
The third tab is also obvious, it's for the prices related to each product.
Last one is with information of the costumers.

What I would like to know, is it possible to get the ordered amounts from the second tab. Then create a row with this amount on the first tab with it's Date and Description.

This might be what you are looking for. I filled in the date column on the Factuur worksheet. This was done to help in calculating. The first date for each series of the same date is visible, the others are hidden with Conditional Formatting.

You're welcome. Thanks for the feedback.

When entering dates on the invoice, enter the date on each row. If the date is the same as the one above it, it should be hidden after entry. A new date should remain visible.

If that solves your problem please mark the thread as SOLVED.
You will find this under Tools just above your first message.