working with data between worksheets
 

I have a form which captures multiple lines of data (a daily report, but not
always with the same number of lines), I need to easily be able to
move/copy/export the daily data to a worksheet which will represent data for
the month. In the month worksheet, I will be using filtering to sort the data
as needed. I am looking for some way to automate the data transfer from the
original form to the monthly sheet without using select and copy. Any help?

I think you'd be better off keeping the data in one location and applying
filters directly to that data.

But if you really need to...

I'd steal some code from Debra Dalgleish'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 maybe Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

steve wrote:

I have a form which captures multiple lines of data (a daily report, but not
always with the same number of lines), I need to easily be able to
move/copy/export the daily data to a worksheet which will represent data for
the month. In the month worksheet, I will be using filtering to sort the data
as needed. I am looking for some way to automate the data transfer from the
original form to the monthly sheet without using select and copy. Any help?

--

Dave Peterson