I have this macro which looks at a spreadsheet and populates another with values ie. standards. I have added rows and columns to the original spreadsheet since new units and codes have been created and I was able to change the macro to include the additional rows but I think that it is not looking far enough to the right to include the new columns. I have columns up to AZ but it seems that the macro doesn't fill in values for anything past column AP. I didn't write the macro and am by no means an expert but I just need to figure out what line tells the macro what columns to look at. Here is the portion I believe is relative to this operation:

Range("J2:J10000").FormulaR1C1 = _
"=INDEX('[Macro Holder for Weekly Report 3.xlsm]SectionTimings'!SectionTimings,MATCH(RC[-4],'[Macro Holder for Weekly Report 3.xlsm]SectionTimings'!R1C1:R420C1,0),MATCH(RC[-8],'[Macro Holder for Weekly Report 3.xlsm]SectionTimings'!_FilterDatabase,0))"
Range("K2:K10000").FormulaR1C1 = "=IF(ISNA(RC[-1]),"""",RC[-1])"
Columns("K:K").Copy
Columns("J:J").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
Columns("K:K").Delete Shift:=xlToLeft
Range("J1").FormulaR1C1 = "Standard"
Columns("J:J").TextToColumns Destination:=Range("J1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
Range("I1").AutoFilter
Range("I1").AutoFilter

I have attached the macro holder and the raw data file. I have both open then hit CTRL+A with the EmpAnal_RAW_07-21_08-03.xlsx file active to run the macro and it should fill in the standards for all the units and create a report and so on. My main issue is getting all the standards to be populated. I realize that there are many blanks in the macroholder and I'm filling them in as time goes by but even those that do have data filled in (specifically 464 [column AW]) are not getting populated in my finished spreadsheet.

Thanks in advance for any help you can offer.

Luis