| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract data from one range and place in the same sheet
Col A-------------------Col B------------------ColC---------------------------
Col D-----------------------ColE Name-------------------Date-------------------Amount----------------------" Mary"-------------------- Apr-09 John------------------01-Apr-09--------------$100 ------------------------ 01-Apr-09---------------$125 Mary------------------01-Apr-09--------------$125----------------------------- 02-Apr-09---------------$567 Raj--------------------02-Apr-09---------------$50---------------------------- --04-Apr-09---------------$321 Mary------------------02-Apr-09---------------$567 John-------------------03-Apr-09---------------$213 Bill--------------------03-Apr-09----------------$456 Mary-----------------04-Apr-09-------------------$321 Cathy----------------06-Apr-09---------------$310 Mary------------------01-May-09--------------$78 Raj---------------------02-May-09--------------$567 D1 has dropdown list of Names,and E1 has drop down list of Mon-YY. I need a macro code to get Mary's Apr-09 data from the used range A1:C to D2:E32. If I select Mary(cell D1) and Apr-099Cell E1) ,the output should display like above. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200904/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I pull data from one sheet and place it in another? | Excel Discussion (Misc queries) | |||
| extract data from range,and place in the same sheet | Excel Discussion (Misc queries) | |||
| Grabbing data from 1 sheet to place in another | New Users to Excel | |||
| Use a range value in place of sheet name | Excel Discussion (Misc queries) | |||
| extract data from a random list & place in another ordered list | Excel Discussion (Misc queries) | |||
Threaded Mode
