I am a medical biller and I need to keep track of specific CPT codes and billed dates so that they dont overlap. Is there a way for me to be able to pull the dates from one report (yes excel) to another workbook and when it does can i make it so that it automatically voids the unallowed fellow cpt code from being billed on the following cycle. for example:
3 different procedures
1- 99490 chronic care
2 -G0179 (billed with 1 day date) and (2 x’s) G0181 (covers a 60 day period this is why this gets billed 2 times) home health ( date ranges are as follows 0179-01/08/24 to 01/08/204; 0181 1 u 01/09/24 to 01/31/24 0181 1 u 02/01/24 to 02/29/24
3- 99457, 99454 Remote patient monitoring
1 and 3 can fall in the same 30 day period but 1 and 3 cannot be billed in the same time frame as 2
How can i make it so that when the data is entered it will block out the same time period for the other 2 billings. if that is even at all possible

I am a novice with excel