Can anyone one help??
Hi, I have a worksheet that contains (to make it simple) the folowing info: Customer date shop cost sam 23/11/2005 asda £23.50 john 16/11/2005 tesco £14.60 marc 12/11/2005 sainsburys £15.00 andy 14/11/2005 M & S £23.50 steve 12/11/2005 sainsburys £19.00 paul 14/11/2005 M & S £15.00 bill 23/11/2005 tesco £12.00 burt 16/11/2005 sainsburys £100.00 fred 12/11/2005 M & S £14.00 What i Need t do is have a seperate tab for each customer which shows the same information (i.e. like a filter but shown on a different tab). I can do this using a combination of if & lookup functions, but get big gaps in the data? Probably not very clear what I want to do, but if anyone can help :) -- sammy2x ------------------------------------------------------------------------ sammy2x's Profile: http://www.excelforum.com/member.php...o&userid=29674 View this thread: http://www.excelforum.com/showthread...hreadid=493839 |
Can anyone one help??
Maybe...
Debra's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb or Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm sammy2x wrote: Hi, I have a worksheet that contains (to make it simple) the folowing info: Customer date shop cost sam 23/11/2005 asda £23.50 john 16/11/2005 tesco £14.60 marc 12/11/2005 sainsburys £15.00 andy 14/11/2005 M & S £23.50 steve 12/11/2005 sainsburys £19.00 paul 14/11/2005 M & S £15.00 bill 23/11/2005 tesco £12.00 burt 16/11/2005 sainsburys £100.00 fred 12/11/2005 M & S £14.00 What i Need t do is have a seperate tab for each customer which shows the same information (i.e. like a filter but shown on a different tab). I can do this using a combination of if & lookup functions, but get big gaps in the data? Probably not very clear what I want to do, but if anyone can help :) -- sammy2x ------------------------------------------------------------------------ sammy2x's Profile: http://www.excelforum.com/member.php...o&userid=29674 View this thread: http://www.excelforum.com/showthread...hreadid=493839 -- Dave Peterson |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com