Making data in appear in one worksheet from another

[MarkFarrers]

Dear All,

I am looking for help to see if this possible. I have a spreadshee
containing a list of customers (name etc) and one column shows whether
client has paid or not. We also have a date the customer's order wa
processed.

What I would like to do, if possible, is have some way of running
search or macro on the entire Client List worksheet to check if
client's order is over 21 days old and if they have paid or not. If the
haven’t paid and 21 days has elapsed I would like the data for thos
customers to appear in the Aged Debtors worksheet.

I have attached an example of what I am looking for. Whilst this look
straightforward from the attached, my actual customer list is over 140
entries, hence the need for automisation.

Many thanks for any help in advance

+-------------------------------------------------------------------
|Filename: test.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=586
+-------------------------------------------------------------------

 

[Don Guillett]

Dear All,



I am looking for help to see if this possible. I have a spreadsheet

containing a list of customers (name etc) and one column shows whether a

client has paid or not. We also have a date the customer's order was

processed.



What I would like to do, if possible, is have some way of running a

search or macro on the entire Client List worksheet to check if a

client's order is over 21 days old and if they have paid or not. If they

haven’t paid and 21 days has elapsed I would like the data for those

customers to appear in the Aged Debtors worksheet.



I have attached an example of what I am looking for. Whilst this looks

straightforward from the attached, my actual customer list is over 1400

entries, hence the need for automisation.



Many thanks for any help in advance.





+-------------------------------------------------------------------+

|Filename: test.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=586|

+-------------------------------------------------------------------+

No need for a separate sheet. Just assign each of these to a button on the MAIN sheet

Option Explicit

Sub FilterUnPaidsOver21DaysSAS()
Dim lr As Long
lr = Cells.SpecialCells(xlCellTypeLastCell).Row
With ActiveSheet.UsedRange
..AutoFilter Field:=11, Criteria1:="="
End With
End Sub

Sub Unfilter()
If ActiveSheet.AutoFilterMode Then Selection.AutoFilter
End Sub

 

[MarkFarrers]

;1605629']On Monday, September 17, 2012 10:05:56 AM UTC-5, MarkFarrer
wrote:-

Dear All,



I am looking for help to see if this possible. I have a spreadsheet

containing a list of customers (name etc) and one column shows whethe a

client has paid or not. We also have a date the customer's order was

processed.



What I would like to do, if possible, is have some way of running a

search or macro on the entire Client List worksheet to check if a

client's order is over 21 days old and if they have paid or not. I they

haven’t paid and 21 days has elapsed I would like the data for those

customers to appear in the Aged Debtors worksheet.



I have attached an example of what I am looking for. Whilst thi looks

straightforward from the attached, my actual customer list is ove 1400

entries, hence the need for automisation.



Many thanks for any help in advance.





+-------------------------------------------------------------------+

|Filename: test.zip |

|Download http://www.excelbanter.com/attachment.php?attachmentid=586|

+-------------------------------------------------------------------+

No need for a separate sheet. Just assign each of these to a button o
the MAIN sheet

Option Explicit

Sub FilterUnPaidsOver21DaysSAS()
Dim lr As Long
lr = Cells.SpecialCells(xlCellTypeLastCell).Row
With ActiveSheet.UsedRange
..AutoFilter Field:=11, Criteria1:="="
End With
End Sub

Sub Unfilter()
If ActiveSheet.AutoFilterMode Then Selection.AutoFilter
End Sub

Thanks very much for your help, I shall give that a go today

+-------------------------------------------------------------------
+-------------------------------------------------------------------