Macro

[eQuestion]

Hello,

Can someone help me please to automate this simple task. I have attached an example.

Thanks

ane

[royUK]

You are not likely to get much help if you can't be bothered to explain your problem in the actual question. Why should we waste time downloading the example without knowing whether we can help? Also, your question title does not give any indication of what you want.

See the contacts form example here

http://www.excel-it.com/vba_examples.htm

[eQuestion]

Hello Roy,

Thanks for your prompt reply. I dont know how to explain it in the title, my apologies. If you can help me please, i have sheet1, that is where i type the data, i just want those data go to sheet 2 in listed format in a macro or vba.

Thanks in advance.

[royUK]

have a look at the example on the page I posted the link to.

[eQuestion]

Roy,

I tried but its blocked here in the office. I tried to code it but its not working.
I tried to record a macro, then edit macro, then see the code, but its still not working.

Ane

[corinereyes]

Hi Ane,

See the attached file. You may continue to learn VBA through Roy's website. Learn the Offset Function, it is very helpful.

Roy, Since Ane cant download the example you have in your site, i've managed to download and make the code worked for her. Thanks Roy.

If you have any question just post it.

Corine