I am trying to take data from my YTD sheet and given a criteria on that sheet
automatically fill in on other sheets. Is this possible?
Please help.
Mike
Yes.
How about some particulars on your data and how it's set up on your YTD
sheet?
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
quot;Mike F.quot; gt; wrote in message
...
I am trying to take data from my YTD sheet and given a criteria on that
sheet
automatically fill in on other sheets. Is this possible?
Please help.
Mike
I keep a log of all my customers and the specific information about each of
their move. Each one is seperated at the end of each month by 1 of 3
options: W/A, Yes, No. I am trying to have all the W/A customers copy over
to the W/A sheet and so forth. All the intial information is placed on the
Current Month sheet.
I can send you an email of what I am doing considering I can't paste or
attach on the discussion thread.
Mike
quot;RagDyeRquot; wrote:
gt; Yes.
gt;
gt; How about some particulars on your data and how it's set up on your YTD
gt; sheet?
gt; --
gt;
gt; Regards,
gt;
gt; RD
gt; ----------------------------------------------------------------------------
gt; -------------------
gt; Please keep all correspondence within the Group, so all may benefit !
gt; ----------------------------------------------------------------------------
gt; -------------------
gt;
gt; quot;Mike F.quot; gt; wrote in message
gt; ...
gt; I am trying to take data from my YTD sheet and given a criteria on that
gt; sheet
gt; automatically fill in on other sheets. Is this possible?
gt;
gt; Please help.
gt; Mike
gt;
gt;
gt;
gt;
Maybe...
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
Mike F. wrote:
gt;
gt; I keep a log of all my customers and the specific information about each of
gt; their move. Each one is seperated at the end of each month by 1 of 3
gt; options: W/A, Yes, No. I am trying to have all the W/A customers copy over
gt; to the W/A sheet and so forth. All the intial information is placed on the
gt; Current Month sheet.
gt;
gt; I can send you an email of what I am doing considering I can't paste or
gt; attach on the discussion thread.
gt;
gt; Mike
gt;
gt; quot;RagDyeRquot; wrote:
gt;
gt; gt; Yes.
gt; gt;
gt; gt; How about some particulars on your data and how it's set up on your YTD
gt; gt; sheet?
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; RD
gt; gt; ----------------------------------------------------------------------------
gt; gt; -------------------
gt; gt; Please keep all correspondence within the Group, so all may benefit !
gt; gt; ----------------------------------------------------------------------------
gt; gt; -------------------
gt; gt;
gt; gt; quot;Mike F.quot; gt; wrote in message
gt; gt; ...
gt; gt; I am trying to take data from my YTD sheet and given a criteria on that
gt; gt; sheet
gt; gt; automatically fill in on other sheets. Is this possible?
gt; gt;
gt; gt; Please help.
gt; gt; Mike
gt; gt;
gt; gt;
gt; gt;
gt; gt;
--
Dave Peterson
- Nov 18 Sat 2006 20:10
Auto fill
close
全站熱搜
留言列表
發表留言