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!![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
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.
![596619d1541253069-excel-find-copy-and-paste-in-another-sheet-macro-for-multiple-documents-report2.jpg](/board/proxy.php?image=https%3A%2F%2Fwww.excelforum.com%2Fattachments%2Fexcel-programming-vba-macros%2F596619d1541253069-excel-find-copy-and-paste-in-another-sheet-macro-for-multiple-documents-report2.jpg&hash=d8876dc591af54781491afee73c19a20)
And i would need to obtain a summary alike that:
![596620d1541253544-excel-find-copy-and-paste-in-another-sheet-macro-for-multiple-documents-summary2.jpg](/board/proxy.php?image=https%3A%2F%2Fwww.excelforum.com%2Fattachments%2Fexcel-programming-vba-macros%2F596620d1541253544-excel-find-copy-and-paste-in-another-sheet-macro-for-multiple-documents-summary2.jpg&hash=eaaf5b58bc6447f37973f664d1a4d9e3)
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!
![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)