Selecting and paste into new sheet.

[calvinle]

Hi,

Base on this thread as reference:
http://www.excelforum.com/excel-prog...new-cells.html

I have the same issue, but my data are all in 1 cell instead of separate cells.
The result on my sample Sheet 2, I use RIGHT, MID to pull the data, so I wonder if I can run a macro to have all the data in 1 click.
The header in Sheet 2 is to show you the order of the data to pull, having them or not is not the main thing. I need the data in the same order, that is more important.

format.xlsx

Please help!

Thanks.

[Richard Buttrey]

Hi,

You don't necessarily need a macro. You can use a helper column as in the attached.

[calvinle]

Hi,

I dont quite understand how that helper does.. or how to setup that helper? If I need more field to be added to my data?

Thanks

[Richard Buttrey]

Yes, the helper cells are a new series of cells. You can of course tuck them away somewhere else or hide the row if you don't want to see them.

Using helper cells is a fairly common technique, often used to avoid complicating other formulae too much.