transfer data from one excel sheet to another

  • Thread starter Thread starter Exceloficio
  • Start date Start date
E

Exceloficio

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.
 
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" <[email protected]>
wrote in message
news:[email protected]...
 
It looks like the advanced filter will work for me. Thank You very muc
for your help
 
Back
Top