One cell acting on another

5 pts.
Tags:
Microsoft Excel
I have a complex question...so bad, in fact, that there's a screenshot that better explains what I need: http://junk.tecsbrain.org/excelquestion.gif Basically, I get a bunch of values from a listing, punch them in, and then correct any mistakes in those values. Right now, I manually move from one to the next with a matrix of cells where I'll subtract from one and move it to the other, but I'd like to automate this process. So, can one cell's value be altered by input from another cell? What formula or macro could I use for this? Any ideas? Much appreciated!

Answer Wiki

Thanks. We'll let you know when a new response is added.

Your graphic doesn’t work. 

You are doing data entry instead of copy and paste.  Always a problem. 

First order of business should be accessing the source data directly, which means you have no data entry errors.  You may have to massage the data by first plunking it into a word processor to replace spaces with tab characters to produce tab delimited data.

After that, comes the text editor.  Copy from the word processor and paste into the text editor to strip formatting that the table doesn’t understand.  You immediately select all in the text editor, copy, and paste into your matrix. 
~~~~

Usually, number dependencies are created during data validation type operations.  However, when you create dependencies, there is typically source data and result data.  Entering data into one cell can modify another but entering data into the dependent (variable) cell obliterates the underlying equation entered in the cell.  Otherwise, you an end with circular logic that will kill your processor as one cell tries to reconcile its value with it’s mate – at 2.53GHz speed. 

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following