Hello, I was wondering on how to write an excel VBA script that has all of the highlighted data and have it be automatically copied and saved into a module that when it is run would just copy it from the NPI # & Codes worksheet into the other worksheets and have it be pasted into the following empty cells in the screenshots below:

If that dosent work please give a simple python script that when ran would do the same thing. Thanks!

Transcribed image text