So I have an nPrinting app that dumps the correct data into an excel file using a template file.
The template file has the charts to be added in tab 1 and in tab 2, the info collated from tab 1 using a hlookup populate the excel table.
This tab 2 has a number of hlookups.
The Template has the correct hlookups on tab 2.
When nPrinting does its dump and the newly created excel file is created, the vlookups change to the last empty cell.
So realistically, =HLOOKUP(Output!D$1,'raw data'!$C$1:$BP2,$A2,FALSE) is in the template (nPrinting shouldnt have to do anything with this sheet either.
When nPrinting does its job =HLOOKUP(Output!BQ$1,'raw data'!$C$1:$BP58,$A2,FALSE) appears in Cell BQ2 and all of BQ is now changed.
Attached are the template and output for a better example.
Any help would be appreciated.
I could manually change it from =HLOOKUP(Output!BQ$1,'raw data'!$C$1:$BP58,$A2,FALSE) to =HLOOKUP(Output!BQ$1,'raw data'!$C$1:$BP2,$A2,FALSE) manually and expand that row but i shouldnt have to.
