Can you do this in Excel

		Microsoft Office Forums > Microsoft Excel > Excel
Can you do this in Excel

FAQ

Thread Tools

Display Modes

02-18-2023, 11:51 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

Quote:

Originally Posted by rkebab

Can this be done without code?

You can create an ODBC query on sheets a, b, and c, which read data from your main sheet with WHERE clause set. You can set those queries to be refreshed when workbook is opened, and user can refresh queries manually at any time too.

But the question remains, for what do you need this at all? I can't see any valid reason for this!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word)	Windspeed	Excel	10	08-03-2022 04:29 PM
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data?	Hoser	Word	1	03-17-2017 03:47 PM
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet?	ADubin	Excel Programming	3	02-08-2015 04:57 AM
[Excel 2007] Building Power Point Slides from data in an Excel Table	bremen22	Excel Programming	1	08-07-2013 11:01 AM
Excel 2011 can't open old Excel 98 or Excel X files	FLJohnson	Excel	8	05-09-2012 11:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:47 PM.