Excel 2007 : Macros?

[Gurjyot]

Alright, I want that in the first sheet I enter some values in first column like cars and trucks repeatably in any way.
And some value into the second column.
I want that all the cars items with the values automatically comes in the sheet two and all the trucks with values comes in sheet three.
It automatically comes over there when I enter them in sheet one.
Please help me.
Thank you.

People answered it is Macro, can you link me some videos or some ways to do them?
Thank you.

[jeffreybrown]

It's possibly called a Macro, but unfortunatley your thread title leaves much to be desired.

Please consult the forum rules about thread titles and amend accordingly.

[Gurjyot]

It's possibly called a Macro, but unfortunatley your thread title leaves much to be desired.

Please consult the forum rules about thread titles and amend accordingly.

Alright I've changed the title.
Can you give me some tutorials how to do it?
Thanks alot.

[FDibbins]

I think what jeffreybrown was trying to say was...change your thread to something that describes your question, something that, when we look at it, gives at least some idea of what you are trying to achieve or what you are having a problem with....perhaps something like "how to get values from 1 sheet to automatically carry across to another sheet"

the reason for this is that not every1 has the time to oopen all threads, and some may have an interest in helping with a small range of question types. by reading the thread, that lets them know to open the thread and get more info. otherwise they may just pass your thread up and move on to the next 1

[Gurjyot]

I think what jeffreybrown was trying to say was...change your thread to something that describes your question, something that, when we look at it, gives at least some idea of what you are trying to achieve or what you are having a problem with....perhaps something like "how to get values from 1 sheet to automatically carry across to another sheet"

the reason for this is that not every1 has the time to oopen all threads, and some may have an interest in helping with a small range of question types. by reading the thread, that lets them know to open the thread and get more info. otherwise they may just pass your thread up and move on to the next 1

Alright, changed.

[jeffreybrown]

http://www.mrexcel.com/forum/showpos...97&postcount=5

[royUK]

Have you even bothered to read the Forum Rules?