Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel macro to extract data from one worksheet to many spreadsheets
Hi all
is there a macro i can write for the following: I have one worksheet with extracted data, lets say as an example columns a-g are populated with data, however each of the rows contains mulitple data lines for each record for different dates. The columns could contain, name, job title, course start, course finish, course title, cost centre, cost (£). I would like to extract the data from the one worksheet to many spreadsheets, but would like it to sort the data in the following way (as an example): Course Title Total cost cost centre i would like to have one line for each of the course titles (rather than multiple lines) sorted by cost centre and the macro should be able to take all the mulitple data and translate it into one line for each. I appreciate any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare spreadsheets & then extract data | Excel Discussion (Misc queries) | |||
Macro to Extract Template Data to New Worksheet | Excel Worksheet Functions | |||
select and extract rows of data to new excel worksheet | Excel Worksheet Functions | |||
Excel - Extract data from one worksheet to many spreadsheets ... | Excel Programming | |||
excel macro to extract data from one worksheet to many spreadsheets | Excel Programming |