I am brand new at this, sorry if I am not clear. I have a production
sheet in excel. What I want is on another sheet have the rows copy
automatically when a date is put in column D on the production sheet,
to the next available row on the other sheet, but I do not need all the
columns. Out of 29 Columns in the production sheet I only need 6 of
them copied to the new sheet. Example on the production sheet I have
columns A-AC, when I add a date to column D in the production sheet I
want only column D, F, H, N, T, and U to copy on the other sheet.

When the information is on the other sheet it also auto sorts by column
D of the new sheet.

If anyone can help I would appreciate it.
Thank You.