Where do the drop down 'sort boxes' in row 2 come from on a blank sheet2 ???
Well, if Sheet2 was completely blank the AutoFilter drop-downs (Filters not "sort boxes") would go in C1:E1 and that would be fine as I understand the problem. However, I did list in my assumptions that Sheet2 had something in column F. In that case, the AutoFilter drop-down will go in columns C:E but in the row where the last data in column F is.
... and where do they go to if you repost the data ???
The second (and subsequent) time(s) the code is run, the drop-downs will still go in columns C:E and in the row where the last data in column F is. That means they will actually be filtering the new
data as that new data will start in the next row after the last data in column F
Good code but it is complex for me and yet very useful for increasing my knowledge of excel.
However how does it seem to a first time postee.
Well, that depends on the level of knowledge the first-time poster has. I have no idea in advance, but if the poster wants further explanation, they can always ask - just as you did.
It all depends on just how you approach a task. Your code (I haven't actually tested it) loops through each row in Sheet1 looking for data in either col C or col E. If it finds data, that row is copied to Sheet2 and a date stamp applied. I have no problem with that logic though I do note that looping can be a bit slow if there are lots of rows, so I usually try to avoid it if possible.
I just took a different approach: Copy everything across to Sheet2, apply a date stamp to the whole copied range and then delete (at once using AutoFilter) all the copied rows that had no data in columns C or E.
I hope this answers your questions.