Cell references in formulas

[Brian Lundell]

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 A61 in the second. Cell G11 in the first needs to contain a formula to equal Cell A116 in the second. This goes on for over 1000 formulas. In other words, the cells in the first worksheet are offset down by 5 rows, while the cells in the second worksheet are offset by 55 rows.

I can enter the formulas easily enough one at a time, but this is not the only instance I will have for doing this, and it takes an extraordinary amount of time.

Copy and paste will not do the trick because the data in the second worksheet will not be entered until later.

If anyone has any suggestions on how to automate the process I would be grateful for any direction.

Thanks,

Brian Lundell

[Killer42]

Can you identify any sort of consistent relationship between the positions on the first and second sheets? If not, you might have to write a macro that goes through and sets them all, one by one. In which case, it might be quicker and simpler to create them manually anyway.