Totally VBA newbie here, but found a thread where I could benefit a little from another users file.
"Distribution List Testing.xls"
I have edited a little in the code to fit my need, but I am coming up short at the copy/paste part..
I have managed to get my 2 top rows on the first sheet "oversigt" copied over to the new sheet, but even though I have several rows containing dates within my interval, none of these rows are copied over to my new sheet..
On sheet 3 "VARIABLE" I have inserted a button to run the macro "main" which starts the userform
I simply cannot figure out what I need to change in the code to actually have the selected rows copy/pasted into the new sheet.
I hope I have explained it well enough, but if I haven't, then plz let me know and I will try to explain it better..
PS.. Spreadsheet is mainly in Danish, so if you don't know what something means, I'll translate..