calibanzwei
New Member
- Joined
- Aug 3, 2010
- Messages
- 1
Hi there,
For reporting purposes I need to pull information from different cells/sheets into one...
Basically I have a drop down box for the months and tabled areas for the information – choose ‘July’ and I need to pull information from specific cells on different sheets onto the 'Report' sheet, which can then be printed off.
<o></o>
I’ve been playing with CHOOSE but I don't think it'll work...<o></o>
<o> </o>
=CHOOSE(D2=July, C6=Summary!C20, D6=Summary!D20)<o></o>
<o> </o>
Select July and in C6 put the info from ‘July’ sheet cell C20.....and so on...
It's driving me crazy...and I probably haven't explained it too well
For reporting purposes I need to pull information from different cells/sheets into one...
Basically I have a drop down box for the months and tabled areas for the information – choose ‘July’ and I need to pull information from specific cells on different sheets onto the 'Report' sheet, which can then be printed off.
<o></o>
I’ve been playing with CHOOSE but I don't think it'll work...<o></o>
<o> </o>
=CHOOSE(D2=July, C6=Summary!C20, D6=Summary!D20)<o></o>
<o> </o>
Select July and in C6 put the info from ‘July’ sheet cell C20.....and so on...
It's driving me crazy...and I probably haven't explained it too well