LOOKUP then Delimit

[excellenthelp]

Excellers,

What is the VBA code to find "Website" in a column and then delimit that cell that contains "website" by space?

Sample workbook is attached. The sheet "Data" is what it looks before. The sheet "Desired" is what it should look after. What I want to do is to write a VBA to execute this task instead of manually doing it.

SampleV1.xlsx

Thanks!

[AB33]

Try the attached.

[excellenthelp]

This works well. But it does not when the "Website" is moved to a different row in the same column. Some report would have more data on the top and that causes the cell with "website" in it to move down... so it is variable. When the cell is moved down, the macro deletes the row with "website", making it blank.

Hmm...

[AB33]

Please show me with attachment, why it is not working.

[excellenthelp]

This also would not work if there is a blank row in between the data.

[AB33]

Change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

[excellenthelp]

Just in case, Have a quick look at the updated sample workbook.

SampleV2.xlsm

[AB33]

My code only works on column A data.
The sheet you just attached ("data ") is blank

[excellenthelp]

"Data"... to get the data, run 'download' in the immediate window.

[AB33]

I am not going to download the data for you. Beside, I am reluctant to work on data imported from website in to excel.
Data downloaded from sites have lots of unseen characters which makes hard to work in excel. You need to download the data, clean it up and attach a large sample which mimics your actual data.

[excellenthelp]

Ahh Okay. Wise thinking. Security is necessary. I will put the data on the sheet.

I would like Sheets("Data") to look like what Sheets("Desired1") has... in the highlighted rows (two of them)

Here it is.
SampleV2.xlsm