Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
MaC MaC is offline
external usenet poster
 
Posts: 13
Default Find and return data based on a range

I prefer ADO programming in such cases. You can use SQL query based on data
from few sheets and put result into another sheet.
Even more - if your master sheet will be more than 65536 data rows you can
use access MDB file to store your data.

MaC

Użytkownik "egeorge4"
napisał w wiadomo¶ci
...

Thanks for the help and all the views!

I think I have an answer:
http://www.mrexcel.com/board2/viewtopic.php?t=217752

Thanks again!


--
egeorge4
------------------------------------------------------------------------
egeorge4's Profile:
http://www.excelforum.com/member.php...o&userid=30259
View this thread: http://www.excelforum.com/showthread...hreadid=552996



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Return a range based on a variable Art Excel Worksheet Functions 4 December 18th 09 11:08 PM
Find data in Range, Return Cell Reference Hugh Excel Discussion (Misc queries) 7 April 16th 09 04:22 PM
Return an array of data based on range of date Ken King Excel Worksheet Functions 3 February 27th 09 06:02 PM
return a value based on a range Michael NYC Excel Worksheet Functions 3 September 28th 05 05:49 PM
vba help pls - find min based on a condition and return val of an offset cell Impakt Excel Programming 2 May 17th 05 12:40 AM


All times are GMT +1. The time now is 03:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"