From cell to Cells extracting data

[lapot]

Hi all

I have excel report which has data in one cell but i like to break it down to different cells just below the data cell

for example the attached has data A1 and I manually extracted this under the headers in A3 to E3 , this is just one cell's data but more cells like A1 under Colum A


is there a macro will do this automatically? is this doable?

kind regards

[jindon]

Try

Please Login or Register  to view this content.

[lapot]

Thank you very much this works but only for A1 data,

Is there a way we can carry on extracting A1,A2,A3,A4,.... so on, so on data, basically can any data, that Colum A has, be extracted either below cell or another sheet? As you can see new excel sheet that I attached that the data

carries down.


Many thanks for your help in advance.

[jindon]

Add a worksheet named "Sheet2".

Please Login or Register  to view this content.

[lapot]

That is amazing!! it is working.

It is my fault that I realised there is no gap between each cells extraction on Sheet2 , can this also be added to distinguish the each? If you cant not to worry I will work something out.

It is great job, I cant express my appreciation . Thank you again.

[jindon]

Add one line in bold.

Please Login or Register  to view this content.

[lapot]

what can I say! I though this is never possible but you made it possible. I cant thank you enough. it is working perfectly. Respect!