I attached a document that has additional details on each worksheet but I am trying to get data that imports weekly into the attached spreadsheet to be copied and pasted from that column on the first worksheet to a new column on the 2nd worksheet inside the same workbook.

I would like for this to run automatically without me having to open the document, if possible.

I don't know a lot about VBA so if you can provide me with the code or do it for me, that would be amazing! I have several workbooks that will need this type of automation so any help or instructions to allow me to understand the "how it works" would be great.

Greg

RH INRM.xlsx