close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()