Spreadsheet saveas .csv macro - with data editing

[Ashley1993]

Hi Everyone,

At the moment my data looks like this

School	Child Forename	Child Surname	Parent Surname	Parent DOB	Parent NI	Eligible
school1	cforename1	csurname1	psurname1	1/1/1990	JA123456A	Yes
school1	cforename2	csurname2	psurname2		JA123456B	Missing
school2	cforename3	csurename3	psurname3	1/2/1990		Missing
school2	cforename3	csurename3	psurname3	1/2/1990	JC123456A	No

Is there any possibility to create a macro to export to .CSV with selected columns in a different format and with no headers an example is below in the correct format and a blank column in B
i.e.

JA123456A	pleaseleaveblank	19900101	psurname1
JC123456A		19900201	psurname3

please note the date in the original spreadsheet is DD/MM/YYYY and in the .CSV it needs to be yyyymmdd.

Thanks in advance!

[Ashley1993]

I hope someone can help!

[HaHoBe]

Hi, Ashley1993,

maybe try it like this:

Please Login or Register  to view this content.

It may be very important to you but Forum Rules tell something about a day to wait before pushing.

Ciao,
Holger

[Ashley1993]

Hi Holger,

Thank you for your response.

However When I run that macro it doesn't go into seperate cells, for example:

JA123456A || 19900101 PSURNAME	blank	blank	blank
JA123456A || 19900101 PSURNAME	blank	blank	blank
JA123456A || 19900101 PSURNAME	blank	blank	blank

[HaHoBe]

Hi, Ashley,

you could use TextToColumns to split the contents.

Please Login or Register  to view this content.

Ciao,
Holger

[Ashley1993]

Holger, you are a genius!!! If I am ever in Germany I will come buy you a drink

Thanks