Replicating formulas from different rows

[CJT19]

Hi everyone,

First post. Be kind.

Not sure the title makes sense or does my question any justice.

Basically, I have a team tracker for my business and want it to feed directly into a feedback form I've created. It does that nicely using a simple vlookup formula. Perfect.

However, I need it for 15 agents. I'm 6 in and copying, pasting and changing all of the formulas is driving me insane! Is there any way to copy the sheet for the next agent however shift the vlookup down by one row?

Unfortunately, the data on the feedback form isn't adjacent which means I can't just drag the formula?

If that makes any sense?

Many thanks!

 

[jproffer]

Could you drag them and then copy/paste into the feedback sheet? In other words, the cell references would stay "one cell apart" as you drag down even though you need them 5 cells apart in the feedback sheet...so maybe you could just go into the cell and copy the text (in cell edit mode) and paste it where you want it without the cell references changing.

That's not really an answer to your question, but it would at least eliminate changing formulas for each agent.

 

[CJT19]

Yeah it's a cracking idea but I thought I'd make things more complicated by having the cells all over the place in the feedback form. So they're not all in one column/row. They're scattered.

 

[jproffer]

Well yea, you'd have to copy them one at a time....PITA I know