Hey guys,

I am not sure where to start here

I have 1 sheet that has a column of dates and other values

For each non date, the values below it are associated with it

these values need to be automated so that dates go in the date column on sheet 2 and suit:12345 go into another column.

any ideas?