Excel / CSV query

[Closed]
Report
Posts
1
Registration date
Thursday July 16, 2015
Status
Member
Last seen
July 16, 2015
-
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!