Hey there!
I'm designing some HVAC units with dedicated manufacturer software. After the design is finished the software is automatically generating me a final report of the unit's data, among others, in an excel spreadsheet. The thing is many times I have to make like a shorter summary of the report, on purposes of some projects, other summaries, whatever. And here comes the problem: in generated reports given values (e.g. model name, air flow, weight and so on) everytime are in different cells and I can't make just a simple formulas to copy and paste required information.
Below you can see a screenshot of a part of a report.
And i would need to obtain a summary alike that:
Of course those summaries are much more extended, so it's really inconvenient to do it by hand, this is just to give you the idea.
So I was thinking if it would be possible to write a formula that searches one sheet for a key word (e.g. 'Project'), copy it + value of merged cells on side (1234 - (50)) an finally pastes it in fixed cells in another sheet. It also needs to be applicable to different reports as the values locations varies.
Here you have two example excel files:
https://drive.google.com/open?id=1SVFsMdF7C-K_X7eCh4mb0VZgNgAJZ_JE
Anybody has any idea how to resolve it? I would appreciate any help. If you need something more like more explanation, excel file, etc. just give me a shout.
Thanks in advance for help!
I'm designing some HVAC units with dedicated manufacturer software. After the design is finished the software is automatically generating me a final report of the unit's data, among others, in an excel spreadsheet. The thing is many times I have to make like a shorter summary of the report, on purposes of some projects, other summaries, whatever. And here comes the problem: in generated reports given values (e.g. model name, air flow, weight and so on) everytime are in different cells and I can't make just a simple formulas to copy and paste required information.
Below you can see a screenshot of a part of a report.
And i would need to obtain a summary alike that:
Of course those summaries are much more extended, so it's really inconvenient to do it by hand, this is just to give you the idea.
So I was thinking if it would be possible to write a formula that searches one sheet for a key word (e.g. 'Project'), copy it + value of merged cells on side (1234 - (50)) an finally pastes it in fixed cells in another sheet. It also needs to be applicable to different reports as the values locations varies.
Here you have two example excel files:
https://drive.google.com/open?id=1SVFsMdF7C-K_X7eCh4mb0VZgNgAJZ_JE
Anybody has any idea how to resolve it? I would appreciate any help. If you need something more like more explanation, excel file, etc. just give me a shout.
Thanks in advance for help!