Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from a master over to other worksheets.
I have 188 stores, with 18 different possibilities. ie: store # 1, Western, Fabric, L&G Zone 1, L&G Zone 1A. If I have the master with all of the columns checked (coded) for each store, how can I pull the stores that meet certain cirteria over to a new worksheet? What I know about Excel is very little. I have tried reading the book and looking in the forum for help but can't come up with a solution. I have worked mostly with VLOOKUP, HLOOKUP, and IF formulas. Beyond that I'm lost. -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=514548 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from a master over to other worksheets.
You can set up filters to select the stores which meet certain
criteria. Then you can highlight the visible rows and copy them to another sheet. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from a master over to other worksheets.
Hi CBrausa
You can find a code example here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CBrausa" wrote in message ... I have 188 stores, with 18 different possibilities. ie: store # 1, Western, Fabric, L&G Zone 1, L&G Zone 1A. If I have the master with all of the columns checked (coded) for each store, how can I pull the stores that meet certain cirteria over to a new worksheet? What I know about Excel is very little. I have tried reading the book and looking in the forum for help but can't come up with a solution. I have worked mostly with VLOOKUP, HLOOKUP, and IF formulas. Beyond that I'm lost. -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=514548 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from a master over to other worksheets.
Ron-Am I going to use VBA for this? Each store could have 1, 2, 5 or more special codes that would qualify them for a special list (worksheet). If I use the section, you refered me to, to _Create_a_new_workbook_for_all_Unique_values__ do I just do the advance filter? or do I have to do everything in your tip? I have had no training in Excel. What I know I've figured out pretty much on my own. Your patience and guidance appreciated. -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=514548 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from a master over to other worksheets.
Hi CBrausa
The code is doing everything for you You can send me your test workbook if you want and I will add the code for you On which column do you want to filter ? -- Regards Ron de Bruin http://www.rondebruin.nl "CBrausa" wrote in message ... Ron-Am I going to use VBA for this? Each store could have 1, 2, 5 or more special codes that would qualify them for a special list (worksheet). If I use the section, you refered me to, to _Create_a_new_workbook_for_all_Unique_values__ do I just do the advance filter? or do I have to do everything in your tip? I have had no training in Excel. What I know I've figured out pretty much on my own. Your patience and guidance appreciated. -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=514548 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from a master over to other worksheets.
Ron- I can't zip the file. Program not on my machine. Will attach file in the A.M. thanks for your help. -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=514548 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from a master over to other worksheets.
Ron- Please find attached the file I am working with. Cathy +-------------------------------------------------------------------+ |Filename: Excel Problem1.zip | |Download: http://www.excelforum.com/attachment.php?postid=4389 | +-------------------------------------------------------------------+ -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=514548 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling info from a master over to other worksheets.
I can't see this file because I am not on Excelforum.com
Send me the file private (mail address on my site) If it is to big then delete some rows and send that version And tell me on which column you want to filter -- Regards Ron de Bruin http://www.rondebruin.nl "CBrausa" wrote in message ... Ron- Please find attached the file I am working with. Cathy +-------------------------------------------------------------------+ |Filename: Excel Problem1.zip | |Download: http://www.excelforum.com/attachment.php?postid=4389 | +-------------------------------------------------------------------+ -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=514548 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
first time linking worksheets need some info and help | Excel Discussion (Misc queries) | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
Rollup worksheets into a master worksheet - automatically? | Excel Discussion (Misc queries) | |||
Create a master worksheet based on 2 different worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |