Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique and duplicate data between 2 Excel worksheets | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Auto filling dates on other worksheets with data from a next payme | Excel Worksheet Functions | |||
Finding Data in multiple worksheets | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |