Relative Content

Tag Archive for loopsinsert

Current code is not adding the 4 columns into multiple Workbooks as needed

I am new to VBA coding, but I have repetitive tasks at work that are tedious and I would like to automate. One such tasks is taking ~60 files one for each county in my area and adding an instruction page (which I have done successfully with vba) then adding 4 columns A2:F2 with highlighted headers from my source workbook with the VBA code and inserting this range of 4 columns into each of the 60 workbooks on the second tab.