I need a formula that add text from different sheets.

What kind of value, numeric or text, does each person enter in her/his worksheet?

Numeric value. Each person does enter in her/his worksheet.

paul-elkem said:

Numeric value. Each person does enter in her/his worksheet.

Click to expand...

Good. That simplifies things. Forgat to ask:

How these person-related sheets named?

Also, Do you have the morefunc add-in?

Yes, I use morefunc add-in.

I've not decieded how to name the sheets yet, it could be a employee number or initials, or something else. Maybe you have a suggestion?

Paul

paul-elkem said:

Yes, I use morefunc add-in.

I've not decieded how to name the sheets yet, it could be a employee number or initials, or something else. Maybe you have a suggestion?

Paul

Click to expand...

I'm not sure about its stability and about whether this setup is what you have in mind...

Insert 2 new worksheets, name them First and Last, respectively, and put all the employee sheets between these First and Last.

Some employee sheets...

Sheet1

Formula in B2 is...

=SUBSTITUTE(MCONCAT(IF(THREED(First:Last!B2),","&THREED(First:Last!$A$1),"")),",","",1)

which must be array-entered. As you see, it uses two functions from the morefunc add-in.

Thanks a lot Aladin,
but somehow your solution does not work for me, and I do not understand why. I've done what you suggested: my two employee sheets, named Jane and Owen, are located between two blank sheets named First and Last respectively. In the sheets named Janet and Owen information is entered in Cell A1 (the name) and B2 (a numeric value).

The formula
=SUBSTITUTE(MCONCAT(IF(THREED(First:Last!B2),","&THREED(First:Last!$A$1),"")),",","",1)
is entered in cell B2 in a sheet named Overview which is placed before the sheet named First.

The result is a completely blank cell - none information at all.

But if I enter information in the sheet named First; I type First in cell A1 and 5 in cell B2, well - then I get a result, but only the word First. Owen and Janet can still not be seen.

And if I delete the value 5 in the sheet named First, cell B2 in the overview sheet shows nothing. I'm not an expert, but it seems to me that the formula

=MCONCAT(IF(THREED(First:Last!B2),","&THREED(First:Last!$A$1),"")).

stops after "examin" the sheet named First, and does not continue to the next sheet and so on.

PS
I have tried a different formula =MCONCAT(THREED(First:Last!A1)) in cell A1 in the sheet named Overview, and it works fine. That is - both mconcat and threed funcition seems to work.

First and Last should be completely empty.

Did you enter that Substitute formula using control+shift+enter?

First and Last were all blank.

But I did not enter that Substitute formula using control+shift+enter.

I fact this is the first time I use it, and it's working :P Yeah.

Thanks, thanks a lot.