Excel Code Debug Help Needed

nhbartos

Board Regular
Joined
May 23, 2015
Messages
148
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
 

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
3,828
Hi

I ran it with Excel 2016 and the billing summary seems to populate correctly. Can you test on another machine?
 
Last edited:

Forum statistics

Threads
1,085,843
Messages
5,386,297
Members
401,992
Latest member
CleverHopper

Some videos you may like

This Week's Hot Topics

Top