Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting data from one excel sheet into poreset tabs?
In one of my projects I copy from Access queries into several Excel
spreadsheets. I then go into the Data menu, go to Filtering and select auto filter on a column with Division code to select the rows for each division in each spreadsheet. I cut each of the rowsfor each division and paste it into the corresponding tab for that division. There are ten divisions and I have templates with the tabs already set up. I do this for about five spreadsheets (so I do this about fifty times!) that are then sent to management as reports. I am working with about 400KB to 500 KB of data in each spreadsheet. Can anyone point me to information on automating this within Excel (or maybe Access)? It would cut a mind-numbing task for me and a couple of coworkers who would be very grateful! Thank you, Mark Snyder |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My sheet tabs disappeared with entered data. Can it be restored? | Excel Discussion (Misc queries) | |||
Refresh data from an Excel sheet | Excel Worksheet Functions | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
transfer data from one excel sheet to another | New Users to Excel | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions |