LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eve Eve is offline
external usenet poster
 
Posts: 4
Default How to exchange data?

Hi,

I have an Excel 2007 file with text data in 2 columns like this:
X1 A
X2 B
X3 C
X4 D
X5 E
X6 F
etc.

For some purposes I have to save the date in another file
in the following way:
X1 B
X2 A
X3 D
X4 C
X5 F
X6 E
etc.

The file is big so it would be difficult to do it manually.
How to do it automatically?

Please help me.

Regards
Eve
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I exchange data between worksheets? TucAO New Users to Excel 2 June 27th 07 11:06 PM
How do I exchange data between worksheets? TucAO Excel Programming 3 June 27th 07 10:38 PM
exchange data between two files Darius Excel Worksheet Functions 1 May 21st 05 05:31 PM
Data exchange between a DDE prog and excel Leo Butler Excel Programming 0 December 22nd 04 11:23 AM
Data exchange between vba and excel Thomas Dufaux Excel Programming 1 June 23rd 04 05:40 PM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"