Find a cell, based on a reference and input a character

[Joshua@work]

This is a follow up on an old post of mine, below is the original post. Trebor came up with a Macro that works great, but now I want to add to it. I have attached an example of my spreadsheet. After entering a value in A1 the macro finds that value in a list and takes you to a predetermined cell to the right of that value. I have also set up a time stamp so that if any value is put into that cell a time will appear in the column next to it. What i want the macro to do now is in addition to finding the correct cell, put in a value "X" and return to cell A1. Is this possible??

The end result should be to enter a value, have it time stamp that value in the list and be ready to enter a new value.


Original Post:
Hello All,
What I have is a list of unique file numbers in colmun A and information pertaining to each file in that column,(file name, dates, etc). What I would like to do, is to create a formula where I could enter a reference number into a blank cell, a number that matches one of the numbers in cloumn A, and be taken not only to that column, but a predetermined row next to that column so that I may enter more information.


EXAMPLE: I want to be able to enter say the first number "0732556005" into a cell and automatically be taken to C3 so that I can fill in the blanks.
.......A............................B.....................C
0732556005..............MARTINEZ
0806798004..............HILL
0733453653..............NIETO
0727552104..............PHILLIPPI
0724752147..............STATEN
0827555212..............LAMBSON
0733331605..............JUANGCO
095395JAP..............WARD
0801131590..............TREJO
0705153068..............FOX
096637MLR..............BANSEMER
0618631063..............PETERSON
0617798002..............GANDY
098297MZ..............DACOSTA
0707344543..............HINSEY
097681BKS..............HUCKABY
0733756111..............WELLS
0636034503..............ALVERIO
0728331038..............HOWARD

[Leith Ross]

Hello Joshua@work,

Wouldn't you need to make 2 entries, RFA and Date of RFA, before returning to A1?

[foxguy]

Hi Joshua;
Here's a solution that doesn't change much of Trebor's macro:
replace one line with new code.

Please Login or Register  to view this content.

Important: Make sure that the "Select" is not executed (notice the ['] in front of the line so it doesn't execute).

By changing Target to the cell you want to place an X into, the section of the macro that starts with "With Target" will execute.