software

Hi,

I have a worksheet that contains (to make it simple) the folowing
info:

Customerdate 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 amp; S ?23.50
steve 12/11/2005 sainsburys ?19.00
paul 14/11/2005 M amp; S ?15.00
bill 23/11/2005 tesco ?12.00
burt 16/11/2005 sainsburys ?100.00
fred 12/11/2005 M amp; 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 amp; 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: www.excelforum.com/member.php...oamp;userid=29674
View this thread: www.excelforum.com/showthread...hreadid=493839Maybe...

Debra's site:
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.
www.rondebruin.nl/easyfilter.htm

sammy2x wrote:
gt;
gt; Hi,
gt;
gt; I have a worksheet that contains (to make it simple) the folowing
gt; info:
gt;
gt; Customer date shop cost
gt;
gt; sam 23/11/2005 asda ?23.50
gt; john 16/11/2005 tesco ?14.60
gt; marc 12/11/2005 sainsburys ?15.00
gt; andy 14/11/2005 M amp; S ?23.50
gt; steve 12/11/2005 sainsburys ?19.00
gt; paul 14/11/2005 M amp; S ?15.00
gt; bill 23/11/2005 tesco ?12.00
gt; burt 16/11/2005 sainsburys ?100.00
gt; fred 12/11/2005 M amp; S ?14.00
gt;
gt; What i Need t do is have a seperate tab for each customer which shows
gt; the same information (i.e. like a filter but shown on a different tab).
gt; I can do this using a combination of if amp; lookup functions, but get big
gt; gaps in the data?
gt;
gt; Probably not very clear what I want to do, but if anyone can help
gt;
gt; --
gt; sammy2x
gt; ------------------------------------------------------------------------
gt; sammy2x's Profile: www.excelforum.com/member.php...oamp;userid=29674
gt; View this thread: www.excelforum.com/showthread...hreadid=493839

--

Dave Peterson