| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering data to another sheet
In excel there is a fucntion that can filter particular data in the current page... but can i filter and display in another page!! example sheet1: Col1 Col2 Col3 Col4 abc def ghi jkl bbb ddd ggg jjj bac fed ghi klj eg sheet2: ColX ColY ghi jkl ghi klj so if i have a new data enter in Col3 as ghi in sheet1 then sheet2 will auto have that new record in ColX n ColY!! that is something like linking 2 sheet.. and the data to be life.. -- lsy ------------------------------------------------------------------------ lsy's Profile: http://www.excelforum.com/member.php...o&userid=23917 View this thread: http://www.excelforum.com/showthread...hreadid=375879 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtering data to another sheet
see url
http://www.contextures.com/xladvfilter01.html#ExtractWs =================== lsy wrote in message ... In excel there is a fucntion that can filter particular data in the current page... but can i filter and display in another page!! example sheet1: Col1 Col2 Col3 Col4 abc def ghi jkl bbb ddd ggg jjj bac fed ghi klj eg sheet2: ColX ColY ghi jkl ghi klj so if i have a new data enter in Col3 as ghi in sheet1 then sheet2 will auto have that new record in ColX n ColY!! that is something like linking 2 sheet.. and the data to be life.. -- lsy ------------------------------------------------------------------------ lsy's Profile: http://www.excelforum.com/member.php...o&userid=23917 View this thread: http://www.excelforum.com/showthread...hreadid=375879 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtering data to another sheet
i'm sorry to tell you that the URL is not available... can you pleas resend the correct URL?? thanks. -- ls ----------------------------------------------------------------------- lsy's Profile: http://www.excelforum.com/member.php...fo&userid=2391 View this thread: http://www.excelforum.com/showthread.php?threadid=37587 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtering data to another sheet
the url is
http://www.contextures.com/xladvfilter01.html#ExtractWs repeat http://www.contextures.com/xladvfilter01.html#ExtractWs it is not clear how the url line is missed in my posting. ------------------------------------------------------ lsy wrote in message ... i'm sorry to tell you that the URL is not available... can you please resend the correct URL?? thanks.. -- lsy ------------------------------------------------------------------------ lsy's Profile: http://www.excelforum.com/member.php...o&userid=23917 View this thread: http://www.excelforum.com/showthread...hreadid=375879 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtering data to another sheet
It works fine for me.
-- Regards, Tom Ogilvy "lsy" wrote in message ... i'm sorry to tell you that the URL is not available... can you please resend the correct URL?? thanks.. -- lsy ------------------------------------------------------------------------ lsy's Profile: http://www.excelforum.com/member.php...o&userid=23917 View this thread: http://www.excelforum.com/showthread...hreadid=375879 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering of data - autmatically based on data on other sheet | Excel Discussion (Misc queries) | |||
| filtering data to another sheet | Excel Discussion (Misc queries) | |||
| Filtering sheet data in another sheet | Excel Worksheet Functions | |||
| Filtering data to another sheet | Excel Worksheet Functions | |||
| Filtering data to another sheet | New Users to Excel | |||
Linear Mode
