How to adjust range of cells in VBA

[Smithy007]

Hi All

I am a total Excel novice and am (attempting) using an existing Excel file that has Macros.

The Macros are intended to pull data from one worksheet ('Data') into several others (example shown below) to populate some simple tables. The problem is that the there have been columns added to the original 'Data' spreadsheet and now the tables are getting the information from the incorrect columns.

I need to edit the range of cells that the information is being pulled from, but I have no clue where to start. I am busy watching videos on line and my brain's breaking - I desperately need some help!

An example is shown below: Top image is the simple table being populated and the second is the VBA code for the Macro. It is supposed to populate all columns but is pulling data for the Training Priority from the wrong column, so I am only getting 'x'. How do I make it select the appropriate column in the 'Data' worksheet?

 

[Zot]

The explanation is not clear because there is no reference to sample given.
The columns and rows of your Excel sheet have been cut out. No idea what the columns and rows are.
What column has been added?
How's the original table which the macro worked properly?

Install XL2BB and learn to use it to copy paste range of the sheet. This was your sample no need to be retyped but helpers can just copy paste.