MS EXCEL Multiple Worksheets?

Question

I have a colmun of names in 12 worksheets, Jan.-Dec.,as random entries, with duplications. I want to pull each duplicate name as a "single name" entry into a separate sheet, col., as a recap sheet. I have each name uniquely coded and the "data range" uniquely named for each month.
I should be able to pull these names from all 12 sheets. I could do it by month if necessary.

Can anyone give me the correct function to pull "text" for this purpose.

A function that does the job similar to Dsum for numbers.

I understand Dsum function.
I plan then to use Dsum in order to pull numerical data for each name.

Damn, I knew Lotus 123 inside and out. Long ago.
Haven't done this in Excel. HELP is confusing me.

Answer 1

As I may understand you here, you want the colum in all 12 sheets to be in one sheet, IF this is what you need, yes I did this before. All you need is to send me your address and mark me as best, And I will give you the combination functions.
Read my profile, I am XLMan
If not this want you need, I guess you need a macro to do this, I can do this also, but again, send me your e-mail and mark me as bext

XLMan

Answer 2

I lost you where you said "I have each name uniquely coded and the "data range" uniquely named for each month...."

If you send me your workbook with an example of what you are trying to do I can write a macro that can do the trick. Email me at [e-mail]

PS: If the data is confidential, you can put some dummy data in the workbook - seeing the structure of the data would help me understand your requirement better.

Answer 3

i'm no longer confident Excel kinds them for you yet you may want to do it manually by using clicking on the tab and shifting the sheet to the position you want. That way you may sort them your self. desire this enables a touch.