Attached is a spreadsheet example of my issue.
As you can see from the attachment, I run the report generator for the specific fund number, it populates new data in column C that I have to copy/paste into column B. The SS is just a short example, but the list of funds in column A can reach well into 100+ rows.
Cell B3 can't be B3=C3 (and then dragged down) because when I run the report generator for another fund, it will be blank.
For awhile I had a button with a macro assigned that when after I run the report generator I would click it, and it would take the first row, copy it, and paste it onto another SS. This didn't work too well, because sometimes the first 10 or so rows were the same fund, so I had to run the report generator over and over again for the same fund instead of just copying a block at a time and pasting over to B.
Basically I'm trying to find a way to program it to where it takes all the similar funds in column A, and then takes the generated report in C, and plugs it into B.
Anyhoo, if anyone has done something similar let me know! Thanks!