Hi folks,
I hope this is an easy fix because I am going crazy.
File 1: https://drive.google.com/open?id=0B1W8cwZVnTmPNjQyX0NhQktURG8
This file is how it is supposed to look.
The code for this file was written by another and sent to me.
Apparently, the code runs perfectly in Excel 2016 and 2007 when the writer runs on his machine.
This code needs to run on 2007.
However, when I run the code on my machine it gets all messed up.
Below is the file after the macro at the top of the Sessions Breakdown tab button is re-run (the billing tab and tabs that have therapist names are supposed to be overwritten every time the code is run.)
File 2: https://drive.google.com/open?id=0B1W8cwZVnTmPSExudkhlWXhoV0U
So, the CPT Codes are supposed to populate column(s) D on the Billing and therapist tabs only. They look like this H2019, H2020, H2021, etc...
However, for some reason, another set of CTP Codes are populating column(s) A and shifting all data one column to the right.
You will see bolded CPT Codes in column A in the date column, and they don't seem to match what is populating in column E.
We have been troubleshooting and debugging for a week with no luck!
Any help with this would be appreciated.
Vince
I hope this is an easy fix because I am going crazy.
File 1: https://drive.google.com/open?id=0B1W8cwZVnTmPNjQyX0NhQktURG8
This file is how it is supposed to look.
The code for this file was written by another and sent to me.
Apparently, the code runs perfectly in Excel 2016 and 2007 when the writer runs on his machine.
This code needs to run on 2007.
However, when I run the code on my machine it gets all messed up.
Below is the file after the macro at the top of the Sessions Breakdown tab button is re-run (the billing tab and tabs that have therapist names are supposed to be overwritten every time the code is run.)
File 2: https://drive.google.com/open?id=0B1W8cwZVnTmPSExudkhlWXhoV0U
So, the CPT Codes are supposed to populate column(s) D on the Billing and therapist tabs only. They look like this H2019, H2020, H2021, etc...
However, for some reason, another set of CTP Codes are populating column(s) A and shifting all data one column to the right.
You will see bolded CPT Codes in column A in the date column, and they don't seem to match what is populating in column E.
We have been troubleshooting and debugging for a week with no luck!
Any help with this would be appreciated.
Vince
