Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 11

How to pick data from different sheets conditionally?

I have this question for a long while.

Is that possible to choose data from Sheet1, Sheet2... based on different
conditions? Say, I have market data from Chicago, LA and NYC, each on a
separate sheet, respectively. Can I build a toggle in a summary sheet and
select "Market" and retrieve market data from these markets individually?

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
collecting data from many sheets to one sheet	Khoshravan	Excel Discussion (Misc queries)	12	June 7th 07 10:01 PM
macro	unouwanme	Excel Discussion (Misc queries)	9	August 31st 06 09:38 PM
Macro question	Chris	Excel Worksheet Functions	12	July 7th 06 01:23 AM
consolidation of tables in excel with text and figures	samenvoegen van sheets	Excel Worksheet Functions	8	March 2nd 06 03:27 PM
From several workbooks onto one excel worksheet	steve	Excel Discussion (Misc queries)	6	December 1st 05 08:03 AM

All times are GMT +1. The time now is 11:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us