Search results

  1. C

    Macro to transpose unstructured data

    Hi All, So i have been sent unstructured data which i need in a nice format to analyse. I have attached what i would like the data to look like (the part at the bottom of the image). I dont know if there is any code which would help in getting my data to look in that format. Appreciate any...
  2. C

    Automating a manual task - Monthly duplicated items

    Hi All, Need some help with a large data set that my team handles each month (sample attached). It is rather manual and I have tried, and failed to overcome the manual aspect so am reaching out to anyone that may have had an issue like this in the past or if not, has any good suggestions...
  3. C

    MS Access Funct for RollOut Schedules

    Hi all, I was wondering if someone can assist me with a function I can use in my query which will allow me to calculate the release amount of a prepayment each month until the prepayments dates elapse. Example: current period date: 31 Dec 2020 Prepayment Value $170 Term Start Date: 07 April...
Back
Top Bottom