Pasting data from multiple sheets onto one sheet

**Jhertilus** · 06-30-2013, 11:16 AM

I have created a workbook wilth multiple sheets, with each sheet being exactly the same. I would like to be able to post cells from each sheet onto a new sheet in a results page on a row.

My issue

I want to paste - "=Person!C19&"%"&" - "&Person!B1" down a row with each new entry assuming the name of the next sheet, but instead of getting "=Person2!C19&"%"&" - "&Person2!B1", I get =Person!C20&"%"&" - "&Person!B2

Is there anything short of entering in each value manually that I can do to expidite this process? All subsequent sheets have a the name person2,person3,person4 etc. all the way to 100. Any advice would be greatly appreciated.

**XOR LX** · 06-30-2013, 11:21 AM

??

Why is this different from your other post?

**Jhertilus** · 06-30-2013, 11:29 AM

Same post

Thought it might be better suited in general questions I don't go on forums often

Problem still exists

**XOR LX** · 06-30-2013, 11:31 AM

Have you replied in the other thread to my question?

**Jhertilus** · 06-30-2013, 11:37 AM

yes I'll mark this as solved and continue on the first one.

**arlu1201** · 06-30-2013, 02:53 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.