|
MS EXCEL Multiple Worksheets?
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.
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
Whats On My YouTube Today?
350 Odyssey rollover at Walden Col
Here Are A Few Items From Amazon You Might Be Interested In.
| Account limit of 2212 requests per hour exceeded. |
Items recently purchased on this site:
Thanks for visiting!
Tags: visualization, design, tools, web2.0