Hi. My name is Brian Lundell. I am not a programmer, but very interested. I am creating a program for keeping track of Service Requests at work and am trying to find a way to automate creating a certain segment of code. The problem is as follows:

I have created two worksheets in Excel. Cell G1 in the first needs to contain a formula to equal Cell A6 in the second. Cell G6 in the first needs to contain a formula to equal Cell...