borabora12
New Member
- Joined
- Aug 2, 2008
- Messages
- 12
I have 4 sheets of data, Sheet1, Sheet2, Sheet3, Sheet4
And I have a 5th sheet called "Viewer" inwhich I want to populate based on which selection I make in a drop down menu. Each data sheet has different ranges.
Is there anyway to do this WITHOUT VBA? And without having to make a formula in every cell in the "Viewer" sheet? Thanks in advance.
And I have a 5th sheet called "Viewer" inwhich I want to populate based on which selection I make in a drop down menu. Each data sheet has different ranges.
Is there anyway to do this WITHOUT VBA? And without having to make a formula in every cell in the "Viewer" sheet? Thanks in advance.
