I want to create a report. I have a very large spreadsheet with many
different columns of data and want to create a specific report that when
i hit a button it asks for date range which in turn looks at the
spreadsheet and literally copies and pastes the required data i want
into a new spreadsheet which is my report area. How do i create a search
command to be able to do this and copy the data across.??


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

On 4 Apr, 10:53, Craig Johnson wrote:
I want to create a report. I have a very large spreadsheet with many
different columns of data and want to create a specific report that when
i hit a button it asks for date range which in turn looks at the
spreadsheet and literally copies and pastes the required data i want
into a new spreadsheet which is my report area. How do i create a search
command to be able to do this and copy the data across.??

*** Sent via Developersdexhttp://www.developersdex.com***

try a pivot table with the date you require at page level.

Dave,


Thanks for the reply, could you give me an example of how to do this as
i have not used pivot tables for a very very long time, in fact possibly
since the zx81 was about!!!

Craig Johnson

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