| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and return data based on a range
Hi folks! Looking for the best way to perform a painfully repetitive task! I have 2 sheets of data. - A master sheet with all records (customer data - about 65,000 records/row) - A completion sheet with partial data (customer data - about 50 records/rows) The master sheet looks like this: Job Num Job Type Tech Name City State 1069478 Commercial CH25 Joe Smith Ashlan KY 1068202 Commercial CH25 Steve Jones Portsmouth OH 1061548 Commercial CH25 Kevin Phinney Portsmouth OH 1014500 Residential CH25 Arnold Wright Argillite KY 1071035 Residential CH25 Tim Blue huntington WV The completion sheet looks like this: Job Num Status 1068202 Completed 1061548 Completed 1071035 Completed I need to use the "Job Number" range from the completion sheet to pull the entire matching record/row from the master sheet and paste or display it in a new sheet or the current sheet or .... heck I will take it anywhere! As long as I can search for all completed jobs from the completion sheet in the master sheet all at once! Any help on this is much appreciated! We have been trying to figure this one out for a long time! -- egeorge4 ------------------------------------------------------------------------ egeorge4's Profile: http://www.excelforum.com/member.php...o&userid=30259 View this thread: http://www.excelforum.com/showthread...hreadid=552996 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find and return data based on a range
Get an error message: Excel cannot complete this task with available resources. Choose less data or close other applications. All other applications are closed and I am pretty sure this PC should be able to handle this task... Any other suggestions? -- egeorge4 ------------------------------------------------------------------------ egeorge4's Profile: http://www.excelforum.com/member.php...o&userid=30259 View this thread: http://www.excelforum.com/showthread...hreadid=552996 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find and return data based on a range
Is there any way to use the Query Wizard to search for the multiple job numbers? -- egeorge4 ------------------------------------------------------------------------ egeorge4's Profile: http://www.excelforum.com/member.php...o&userid=30259 View this thread: http://www.excelforum.com/showthread...hreadid=552996 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find and return data based on a range
The master sheet has 51,000 records/rows. Is that to big for VLookup to handle? -- egeorge4 ------------------------------------------------------------------------ egeorge4's Profile: http://www.excelforum.com/member.php...o&userid=30259 View this thread: http://www.excelforum.com/showthread...hreadid=552996 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find and return data based on a range
Works by me (XP Pro + Office 2000 / P4 2Mhz 256 k)
HTH -- AP "egeorge4" a écrit dans le message de news: ... The master sheet has 51,000 records/rows. Is that to big for VLookup to handle? -- egeorge4 ------------------------------------------------------------------------ egeorge4's Profile: http://www.excelforum.com/member.php...o&userid=30259 View this thread: http://www.excelforum.com/showthread...hreadid=552996 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find and return data based on a range
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a range based on a variable | Excel Worksheet Functions | |||
| Find data in Range, Return Cell Reference | Excel Discussion (Misc queries) | |||
| Return an array of data based on range of date | Excel Worksheet Functions | |||
| return a value based on a range | Excel Worksheet Functions | |||
| vba help pls - find min based on a condition and return val of an offset cell | Excel Programming | |||
![egeorge4[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
