Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transfer data from one excel sheet to another
Hello, We currently receive analysis data from a contractor on an excel spreadsheet that contains more information than we need. I would also like to rearrange the data into another excel spreadsheet that is easier for me to look at the data. We reenter the data into a paradox database( Yes, it is archaic) that is very difficult to change the format. Is there a way to automatically rearrange and transfer the data to another excel spreadsheet via a macro, xml, etc? My experience with excel is limited and I only know basic functions. Thank You. -- Exceloficio ------------------------------------------------------------------------ Exceloficio's Profile: http://www.excelforum.com/member.php...o&userid=30940 View this thread: http://www.excelforum.com/showthread...hreadid=506135 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transfer data from one excel sheet to another
Would help to see a small example of the data involved. Have you considered
a Pivot table? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Exceloficio" wrote in message ... Hello, We currently receive analysis data from a contractor on an excel spreadsheet that contains more information than we need. I would also like to rearrange the data into another excel spreadsheet that is easier for me to look at the data. We reenter the data into a paradox database( Yes, it is archaic) that is very difficult to change the format. Is there a way to automatically rearrange and transfer the data to another excel spreadsheet via a macro, xml, etc? My experience with excel is limited and I only know basic functions. Thank You. -- Exceloficio ------------------------------------------------------------------------ Exceloficio's Profile: http://www.excelforum.com/member.php...o&userid=30940 View this thread: http://www.excelforum.com/showthread...hreadid=506135 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transfer data from one excel sheet to another
You can use an Advanced Filter to extract some of the data to another
sheet. There are instructions in Excel's Help, and he http://www.contextures.com/xladvfilter01.html Exceloficio wrote: Hello, We currently receive analysis data from a contractor on an excel spreadsheet that contains more information than we need. I would also like to rearrange the data into another excel spreadsheet that is easier for me to look at the data. We reenter the data into a paradox database( Yes, it is archaic) that is very difficult to change the format. Is there a way to automatically rearrange and transfer the data to another excel spreadsheet via a macro, xml, etc? My experience with excel is limited and I only know basic functions. Thank You. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transfer data from one excel sheet to another
It looks like the advanced filter will work for me. Thank You very much for your help. -- Exceloficio ------------------------------------------------------------------------ Exceloficio's Profile: http://www.excelforum.com/member.php...o&userid=30940 View this thread: http://www.excelforum.com/showthread...hreadid=506135 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Protecting sheet disables import of extetrnal data in Excel 2003 | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions |