Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

linking excel "cells" to another excel logsheet

Status
Not open for further replies.

emipuss1

Technical User
May 3, 2007
3
CA
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! :)
 
Give us the code to what you have now and perhaps someone will be able to help.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.
 
Because you put form in quotation marks, I suspect that the users are entering data onto a normal Excel spreadsheet. Assuming that to be the case, let's break the problem down. There will some event that causes the new record to be added to the log file. That event can be any number of things but let's say for the moment that a button is pressed. At that point the values in the indicated cells are to be captured, possibly formatted (?), and written to the log. To me that raises the question: what is the log file? Is it another spreadsheet? Is it a text file? Is it something else altogether?

So there are some questions to answer at both ends, but in the middle, it seems fairly straightforward. You will have a (macro) subroutine:
Code:
sub writeLog ()
'some event has triggered this macro
   value1 = cells("k8").value
   value2 = cells("a12").value
   value3 = cells("e10").value
   value4 = cells("j17").value
   value5 = cells("j19").value
'some kind of log file gets opened
'........and written
'........and closed
end sub
note: valuen is a stupid nomenclature but I just wanted to give you the idea.

_________________
Bob Rashkin
 
And I surmise that (to add to Bob Rashkin has so nicely stated) ... when the capture of the entered data is triggered, then you would like to write the [b[values[/b] as Bob has delineated in the next empty row of your log.

So a clear and complete description of what you are trying to accomplish is necessary.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top