Dates in pasted CSV sortable Oldest to Newest but A-Z only in 'lookup' sheet - today??

[MandySea]

Hi there,

New to this forum - joined hoping somebody out there can help me with an issue I'm encountering for the first time today?

I have a workbook, set up years ago, with a 'lookup' sheet and multiple tabs which have CSVs pasted into them daily from which the lookup sheet is populated. I've been using this workbook for years to produce a set of morning reports for production. ONE of the CSVs I've run today is, I think, not being read by the lookup sheet as a date, because as soon as I drop the CSV into the file, the sort function on the date in the lookup sheet switches from 'oldest to newest' to 'A-Z', although on the CSV itself, the date can still be sorted oldest to newest. Yesterday's CSV still works....

Does anybody have any experience of this? Anybody advise what I should be looking for?

Really hope somebody can help me.

Thanks

 

[FormR]

Hi, welcome to the forum.

It sounds like those dates are coming across as text. You can try these steps to convert them to dates.

> highlight the column that contains you dates
> choose "Text to Columns" from the "Data" tab
> choose "Delimited" and click "Next"
> uncheck all the "Delimiters" and click "Next"
> choose "Date" from the "column data format" options, choose the appropriate format from the dropdown box next to it and click "Finish"

 

[MandySea]

Thanks FormR for taking the time to read and respond to my query

Unfortunately, it hasn't resolved my problem.

I'm pulling certain columns from a CSV into a lookup sheet using =IF((PIWIP.001!C3)=0,"",PIWIP.001!C3) for example, and then using that data to lookup and pull together data from various other CSVs. I tried your suggestion on both the formula sheet and the CSV and it didn't work for either. I've pasted just the data from the new CSV over the data from the old CSV and the lookup sheet still is able to sort oldest to newest. If I paste the header OR delete the additional rows on the CSV from the previous day's report, the lookup sheet goes back to offering to sort by A-Z.

I've also tried earlier copies of the workbook in case somebody had made a change I was unaware of, but still, it's today's CSV which causes the problem.

I think I'm going to have to create a new workbook to do the same thing and cross my fingers that whatever had changed won't be the same in the new book, AND, try today's workbook when tomorrow's CSV becomes available...

Thanks again for your advice