The attached workbook (GetJobs) shows a way to get the data you want. Use the Worksheet_Change event to launch a subroutine to retrieve the desired information. It is not very elegant but does appear to work. If you have any questions let me know. Tom
On Sat, Dec 27, 2008 at 3:00 AM, konark vyas <kona...@gmail.com> wrote: > Hi, > > I have a data range in sheet 1 and in sheet 2 i want to view some specific > information as attached. Please help me on this. > > Thanks in advance. > > > > Regards, > > Konark Vyas > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
GetJobs.xls
Description: MS-Excel spreadsheet
