Ok, I keep putting posting on but i dont know where they are going, i
have written a program i have all functions working apart from two
reporting facilities i need. The problem is this, i need to be able to
have the user enter a date range in a inputbox and a client name and it
whizzs off to one spreadsheet that contains all the data, and when it
meets with both date conditions and client specified condition it simply
copies the entire row of date and copies it into another blank
spreadsheet, which is the report, and it continues to do the is function
until the end of the spreadsheet is reached thus creating a client
history report for the date range specified.

If anyone would like to look at the progarm with spreadsheet it would be
appreciated as i have got everhting completed except this function and
it is driving me mad.!!!


Craig Johnson

*** Sent via Developersdex http://www.developersdex.com ***

One way would be with a for/each loop
for each c in range("a2:a22")
if c=mydate and c.offset(,2)="Joe" then c.entirerow.copy etc
next
OR
autofilter the source and just copy all at once. Record a macro to see how
it works.


--
Don Guillett
SalesAid Software

"Craig Johnson" wrote in message
...

Ok, I keep putting posting on but i dont know where they are going, i
have written a program i have all functions working apart from two
reporting facilities i need. The problem is this, i need to be able to
have the user enter a date range in a inputbox and a client name and it
whizzs off to one spreadsheet that contains all the data, and when it
meets with both date conditions and client specified condition it simply
copies the entire row of date and copies it into another blank
spreadsheet, which is the report, and it continues to do the is function
until the end of the spreadsheet is reached thus creating a client
history report for the date range specified.

If anyone would like to look at the progarm with spreadsheet it would be
appreciated as i have got everhting completed except this function and
it is driving me mad.!!!


Craig Johnson

*** Sent via Developersdex http://www.developersdex.com ***

BTW.
HELP is a lousy subject line that does nothing for the archives.

--
Don Guillett
SalesAid Software

"Craig Johnson" wrote in message
...

Ok, I keep putting posting on but i dont know where they are going, i
have written a program i have all functions working apart from two
reporting facilities i need. The problem is this, i need to be able to
have the user enter a date range in a inputbox and a client name and it
whizzs off to one spreadsheet that contains all the data, and when it
meets with both date conditions and client specified condition it simply
copies the entire row of date and copies it into another blank
spreadsheet, which is the report, and it continues to do the is function
until the end of the spreadsheet is reached thus creating a client
history report for the date range specified.

If anyone would like to look at the progarm with spreadsheet it would be
appreciated as i have got everhting completed except this function and
it is driving me mad.!!!


Craig Johnson

*** Sent via Developersdex http://www.developersdex.com ***

SOrry DOn i make sure i dont use that subjet line again, i think i wrote
it in frustration.

I will try and do what you said but if it comes to it and i get close to
throwing the computer out the window would you directly have a look at
it, as i really do want to know where i am going wrong.

Craig Johnson

*** Sent via Developersdex http://www.developersdex.com ***

Don,

I used the filter option and it works a treat thanks very much.



Craig Johnson

*** Sent via Developersdex http://www.developersdex.com ***

Glad to help. See how much more fun it is when you do it yourself.

--
Don Guillett
SalesAid Software

"Craig Johnson" wrote in message
...
Don,

I used the filter option and it works a treat thanks very much.



Craig Johnson

*** Sent via Developersdex http://www.developersdex.com ***