ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Auto fill (https://www.excelbanter.com/excel-discussion-misc-queries/60569-auto-fill.html)

Mike F.

Auto fill
 
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



RagDyeR

Auto fill
 
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 !
----------------------------------------------------------------------------
-------------------

"Mike F." 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




Mike F.

Auto fill
 
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




"RagDyeR" wrote:

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 !
----------------------------------------------------------------------------
-------------------

"Mike F." 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





Dave Peterson

Auto fill
 
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

Mike F. wrote:

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

"RagDyeR" wrote:

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 !
----------------------------------------------------------------------------
-------------------

"Mike F." 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





--

Dave Peterson


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com