Again a warning about the Now(). it will update whenever the file is saved
or opened.

"Brandon" wrote:

Hey,
I toyed around with this formula and got it to work:
=IF(A74=Inventory!A51,NOW(),"")
Thanks to all for your help
Brandon

p.s I did it without using any of the macros, thanks to all who suggested
it. I'm going to learn more about them now:)

"JE McGimpsey" wrote:

Check the link to David McRitchie's "Getting Started with Macros"
article on the page I referenced.

In article ,
"Brandon" wrote:

I guess i have to make a macro but i'm pretty unexperienced at that. Any
help would be great.