Makro for finding Date from table and copying content below

Hi I have this code which basically finds the date I need from a table and copies a certain number of cells below and pastes it somewhere else. My question is how I could amend it so that after the first round a question box appears which asks if more dates are needed. If yes again it should be possible to type in the date and number of cells but this time the content will be automatically placed one column right from the previous one.. so in the end I get a listing of selected data. Would be happy if you got a solution...

Thats the code so far:

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I will do it for you this time.)

No problem!

Please attach a sample workbook as requested.

That's code - you already provided that in post #1. I've asked to see the workbook (die Datei, bitte).

Is this the same request?

https://www.excelforum.com/excel-gen...wo-tables.html

Alles klar - danke.