Timmtamm
06-10-2015, 04:33 PM
I'm trying to get two separate tables to reflect some of the values of each other. I thought I might be able to accomplish this by using VLOOKUP in the cells, but have not been able to successfully accomplish this. The area's I'm trying to work on are "Cal Enabled" on the "Design-Summary!" tab, and from the "Design-Calibration!" tab the "Final Conc" and "Accuracy" columns.
In the end, when MassHunter renders the report, the "Cal Enabled" column should have the same boxes in the first instance that appear in the second instance. Also, the second instance of "Final Conc" and "Accuracy" should show the same values as the first instance.
The tables have XML mapping in them, and the data in each table is rendered into a report by a different application (called MassHunter). I tried adding the identical field names (through the XML source list) to the two different tables, but that just came up with empty fields after rendering. That's why I decided to try VLOOKUP.
So to help see the end result, I've included the pre-rendered template, and then the final rendered report. The template is where the changes need to happen. The Quant version is simply there for reference purposes. Hopefully, it is enough to get the idea of how to accomplish this.
I'm not really a programmer. I just tinker with Excel from time to time, trying to pull out spreadsheets that suit my needs better, so my knowlege base is kinda limited.
Thanks so much.
In the end, when MassHunter renders the report, the "Cal Enabled" column should have the same boxes in the first instance that appear in the second instance. Also, the second instance of "Final Conc" and "Accuracy" should show the same values as the first instance.
The tables have XML mapping in them, and the data in each table is rendered into a report by a different application (called MassHunter). I tried adding the identical field names (through the XML source list) to the two different tables, but that just came up with empty fields after rendering. That's why I decided to try VLOOKUP.
So to help see the end result, I've included the pre-rendered template, and then the final rendered report. The template is where the changes need to happen. The Quant version is simply there for reference purposes. Hopefully, it is enough to get the idea of how to accomplish this.
I'm not really a programmer. I just tinker with Excel from time to time, trying to pull out spreadsheets that suit my needs better, so my knowlege base is kinda limited.
Thanks so much.