Excel / CSV query

Mattjones Posts 1 Registration date Thursday July 16, 2015 Status Member Last seen July 16, 2015 - Jul 16, 2015 at 06:52 AM
I will be receiving a weekly CSV data set of holiday information that I need to do the following with:
  • Save into XLS format
  • Create 3 identifier boxes that will say 1: if 14 nights or under

? 2: if 14 to 21 nights
? 3: if over 21 nights
I then need to
  • Pull the full line of information (of all cases identified by 1 above) into a new CSV spreadsheet and save to desktop

If this could all be done via a single click macro it would be brilliant!

The three identifier boxes are required as this will tie in with some CRM software

Thanks in advance, I can send over a trial data set if required, although I have a basic understanding of VBA so can re-hash the box info if needed