I am a VBA virgin, and literally know nothing about it, so all, please be patient. I am about ready to murder my computer and myself!! :>)
I have an excel "form" that people fill in. They do not save the data. What I want is, for certain cells (specifically K8, A12, E10, J17 and J19) to be copies (or linked, or referenced whatever) to a seperate log sheet that someone in another department looks at. They do not need to look at the "form" just the 5 pieces of data from that form.
I would like it to form a running log....so each time a person fills in the electronic form, the 5 cells get copied to another log sheet either via a command button or whatever. I have tried so many different things, but I get lost in the language.
Need help!
Thanks
As a side note - I enrolled in a VBA night class, starts next Thursday!
I have an excel "form" that people fill in. They do not save the data. What I want is, for certain cells (specifically K8, A12, E10, J17 and J19) to be copies (or linked, or referenced whatever) to a seperate log sheet that someone in another department looks at. They do not need to look at the "form" just the 5 pieces of data from that form.
I would like it to form a running log....so each time a person fills in the electronic form, the 5 cells get copied to another log sheet either via a command button or whatever. I have tried so many different things, but I get lost in the language.
Need help!
Thanks
As a side note - I enrolled in a VBA night class, starts next Thursday!