changing contents of a sheet remotely

[R D S]

Hi,
I have a list of jobs on sheet1 col A contains the job number,
Sheet2 is an invoice, i enter job numbers into col A and Vlookups operate in
the other cols.
When i enter a number into sheet2 i would like the row which contains this
job number to have the date entered into col M so i can easily check if a
job has been charged out.

What is the command for this, will it have to be run as a macro?

If i then go on to enter numbers in a list down to cell A38 on sheet 2 is
the best way to write code to look at all the numbers at once and adjust
sheet1 accordingly?

Or input the job numbers via a userform and deal with each one in turn?

Any help appreciated,
Rick

 

[Jonathan Rynd]

When i enter a number into sheet2 i would like the row which contains
this job number to have the date entered into col M so i can easily
check if a job has been charged out.

What is the command for this, will it have to be run as a macro?

Yes it has to be a macro if you want it to run automatically. [You can do
it manually by pressing control-; when you are in the right column.]

The macro has to be entered in the code of the sheet2. You get there by
right-clicking on the tab for Sheet2 and choosing View Code.

 

[R D S]

Jonathan Rynd wrote:
|| ||
||| When i enter a number into sheet2 i would like the row which
||| contains this job number to have the date entered into col M so i
||| can easily check if a job has been charged out.
|||
||| What is the command for this, will it have to be run as a macro?
||
|| Yes it has to be a macro if you want it to run automatically. [You
|| can do it manually by pressing control-; when you are in the right
|| column.]
||
|| The macro has to be entered in the code of the sheet2. You get
|| there by right-clicking on the tab for Sheet2 and choosing View Code.
||
What would the code need to be to match the data from a cell in sheet2 to an
entry in a column in sheet1 and adjust the data in a different column in the
same row?

Cheers
Rick