@macropod Okay here is what my project consists of.
In my department, we are responsible for the testing of our units. There is a performance review sheet for every single unit, this is the document I am pasting into. There is a different document for every unit, it isn't a master document with all the units on it. We use a 3rd party software to collect our data, and then export it into excel. I am trying to write a macro which will automate the process of taking a single cell (the average mean) and pasting it into the performance review doc. This will eliminate the chance of human error. What I have achieved so far is finding the cell I wish to put into excel, open a specific file (I can browse for different files), copy that cell and paste it into one of three bookmarks (depending on a variable in the excel sheet) that are within a table in the doc. The problem I am worried about is having to go through and add the same bookmarks to every single document for each unit.
Let me know if you need more information