Logging data entered to a specific cell

[dyollb]

Hi,

I've been trying to figure out some code that would do the following;

If cell F55 equals "John" it is logged in cell A70, if "John" is changed to "Steve" it is logged in cell A71, if "Steve" is change to "Frank" it is logged in cell A72, and so on. (Names are just an example - Ultimately it would log any data entered into cell F55)

If someone could help me out, that'd be great.

[rylo]

Hi

worksheet change event perhaps

Please Login or Register  to view this content.

rylo

[dyollb]

Thanks Rylo, but that doesn't seem to work.

[rylo]

HI

Build an example file that has your structure, and include the above macro so we can see exactly what you are working with.

rylo

[dyollb]

Example attached.

The table at A70 and downward would be where the changes are to be listed.

Thanks

[dyollb]

Sorry, there's another string of code on that page - Ignore that and enter the one you posted.

[rylo]

Hi

The example file has random data below A70. Remove that data, and try again.

rylo

[dyollb]

Ah yes. Perfect thanks!

What if I also wanted to do the same for cell K55 and log it next to the other data in column C?

[rylo]

Hi

Repeat the if statement test on the address and cell count for K55, and use column C as the output range.

rylo

[dyollb]

Thanks Rylo.