# How to map parent child records in excel

In conga excel format I get repeated requests for conditional values . Any way to use macros? Another question is regarding subqueries . How do we map child records to related parent in excel

##### Post Metadata
- Posted at: about 7 years ago
- Author title: 4 * Salesforce Certified Senior Developer  in Legato Health Technologies
- Net upvotes: 1


## Comments
### Comment 1

Macros don’t do too well because it needs to happen at runtime. 

Instead, I dump the child data into a query on a separate tab in Excel and use sumifs or countifs statements to summary data or vlookup or index match to pull data onto other tabs. 

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: CTO at Stonebriar Commercial Finance




## Related Product
[Conga Composer](https://www.g2.com/products/conga-composer/reviews)

## Related Category
[Document Generation](https://www.g2.com/categories/document-generation)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4