MR_HuffmanEng
New Member
- Joined
- Oct 16, 2018
- Messages
- 1
Overview: I'm currently combining three excel files into one file under three work sheets. Why? The information in all three links to one another and can cascade through all three. This will save us significant time when small changes arise.
Problem: On Worksheet 2, I have Areas designated by letters. Each of these Areas have various values for Flow rates (Q) On Worksheet 3, I have Pipe and Swale information. Users specifies which Areas are included in the calculation (For example, A, B, D, H, K), and I need to have a cell output the sum of the Q for those areas.
I'd appreciate any help you can provide. Worksheets are separated for ease of printing, but can be combined for functionality.
Problem: On Worksheet 2, I have Areas designated by letters. Each of these Areas have various values for Flow rates (Q) On Worksheet 3, I have Pipe and Swale information. Users specifies which Areas are included in the calculation (For example, A, B, D, H, K), and I need to have a cell output the sum of the Q for those areas.
I'd appreciate any help you can provide. Worksheets are separated for ease of printing, but can be combined for functionality.
