Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with a billing sheet
I have a sheet that keeps track of our billing. The summary sheet has the
names of clients, what billing type they are, the amounts they pay per month, who and where they invoices go to. all that information comes from individual sheets within the workbook. Each month I have to send out invoices to all the clients that have a certain invoicing level. normally what i would do is copy and paste each one to the bottom of the page. Is there a way that I can have the rows clients with a specific billing type to be copied to another page or even automatically come up in a list if i use data validation? (for example: on sheet 2, A1 would have a list of the billing types and if i chose a certain billing type a list would form below). any help would be appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with a billing sheet
Dominique
Yes. Your idea of having a Data Validation cell with the billing types, selecting a billing type, and having the associated list of clients appear below (or anywhere you want) is simple to do. You would need a Worksheet_Change event macro tied to a change in that Data Validation cell. If you wish, send me a small file with a sample of your data showing how the data is laid out and where you want the Data Validation cell and the subsequent list. Also include the source list (list of billing types) for the Data Validation cell. Remove "cobia97" from my email address. HTH Otto "Dominique Feteau" wrote in message ... I have a sheet that keeps track of our billing. The summary sheet has the names of clients, what billing type they are, the amounts they pay per month, who and where they invoices go to. all that information comes from individual sheets within the workbook. Each month I have to send out invoices to all the clients that have a certain invoicing level. normally what i would do is copy and paste each one to the bottom of the page. Is there a way that I can have the rows clients with a specific billing type to be copied to another page or even automatically come up in a list if i use data validation? (for example: on sheet 2, A1 would have a list of the billing types and if i chose a certain billing type a list would form below). any help would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Billing Statement Help | Excel Discussion (Misc queries) | |||
Billing Statement Help | Excel Worksheet Functions | |||
Frequency of Billing | Excel Worksheet Functions | |||
Formula for billing water | Excel Discussion (Misc queries) | |||
customer billing | New Users to Excel |