antiga1
11-30-2007, 07:30 AM
Hello!
I want to export some data to a .csv.
It looks like this in Excel:
Column A Column B
Sydney Australien
London England
MAdrid Spanien
Beirut
New Hampshire
Lousville
Conneticut
Boston
The cities in column A are defined as Range("Cities") and those in Column B as Range("Countries").
I can export them but it will look like in excel but I need this in this format in the .csv:
Sydney | London | Madrid | Beirut | New Hampshire |
Australien | England | Spanien | Libanon |
Can anyone help me with the VBA code?
Thanks for your help!!
I want to export some data to a .csv.
It looks like this in Excel:
Column A Column B
Sydney Australien
London England
MAdrid Spanien
Beirut
New Hampshire
Lousville
Conneticut
Boston
The cities in column A are defined as Range("Cities") and those in Column B as Range("Countries").
I can export them but it will look like in excel but I need this in this format in the .csv:
Sydney | London | Madrid | Beirut | New Hampshire |
Australien | England | Spanien | Libanon |
Can anyone help me with the VBA code?
Thanks for your help!!