Combining Multiply Worksheets onto one

[Ninjafer]

I have several worksheets in a workbook that I would like to combine
onto one. All the column titles are the same, but the rows may
change.

Please see the attached example. I would like to know how to make the
"All tab" automatic, since the ranges may change from day to day.

The if possible I would like to make a consolidated tab based on a
criteria.

Thanks!!!


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4564 |
+-------------------------------------------------------------------+

 

[Door]

The attached file should enable you to select the list by Position, but
be aware, the formula in G2 to H18 are all different, but from G18:H18
can be formula-copied down as many rows as are required.

The G column is white-on-white hidden, to allow selection without
displaying repetitive data. Column H is hidden, and extends the If
statements limit of 7 to allow 14 lines of data.
(If the word 'error' appears, you will need another extension, however,
considering your data I doubt there will be any such need).

Hope this helps

I have several worksheets in a workbook that I would like to combine
onto one. All the column titles are the same, but the rows may
change.

Please see the attached example. I would like to know how to make the
"All tab" automatic, since the ranges may change from day to day.

The if possible I would like to make a consolidated tab based on a
criteria.

Thanks!!!

+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4565 |
+-------------------------------------------------------------------+

 

[David McRitchie]

You cannot post to a newsgroups and expect people to read a file
that is reserved to people who signup to post to newsgroups through
Excelforum, the regulars pretty much dislike the slowness of web based
newsreaders, looking at advertisements, or having newsgroups postings
indexed by Google as web pages. Not to mention the use of handles instead
of using real names (first and last). You would have to explain in completely in
words what you want to do. Besides Google Groups Search will not include
anything from outside of the text in the post so it is not helpful to others who
search for answers..

 

[Door]

OK, sorry.

You cannot post to a newsgroups and expect people to read a file that i
reserved to people who signup to post to newsgroups through Excelforum,
the regulars pretty much dislike the slowness of web based newsreaders,
looking at advertisements, or having newsgroups postings indexed b
Google as web pages. Not to mention the use of handles instead o
using real names (first and last). You would have to explain i
completely in words what you want to do

 

[Biff]

They probably don't know that they're posting through a portal.

The owner of that forum gets credit for having a forum where people get
answers yet those answers are overwhelmingly supplied by people from
this/these newsgroups.

You can read the files but you have to read them from that site. You have to
click on the "View this thread" link.

I myself think having the abitily to post files *to a web forum* is a good
thing .. Of course, you take a chance when you open files from strangers!

Biff

You cannot post to a newsgroups and expect people to read a file
that is reserved to people who signup to post to newsgroups through
Excelforum, the regulars pretty much dislike the slowness of web based
newsreaders, looking at advertisements, or having newsgroups postings
indexed by Google as web pages. Not to mention the use of handles instead
of using real names (first and last). You would have to explain in
completely in
words what you want to do. Besides Google Groups Search will not
include
anything from outside of the text in the post so it is not helpful to
others who
search for answers..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

in message

I have several worksheets in a workbook that I would like to combine
onto one. All the column titles are the same, but the rows may
change.

Please see the attached example. I would like to know how to make the
"All tab" automatic, since the ranges may change from day to day.

The if possible I would like to make a consolidated tab based on a
criteria.

Thanks!!!


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4564 |
+-------------------------------------------------------------------+

--
Ninjafer
------------------------------------------------------------------------
Ninjafer's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24711
View this thread:
http://www.excelforum.com/showthread.php?threadid=528938

 

[Peo Sjoblom]

I think Dave meant the OP not you

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Door]

Peo,

I see nothing different in what the OP did to my actions, using a
handle instead of tracking down the password to my name-account, and
posting an attachment with a solution without describing the solution
in the post.

 

[David McRitchie]

Hi Biff,
It is not good for newsgroups -- Robots are not excluded from indexing those secondary
copies of the newsgroups on that site. When was the last time you could do a decent
Google web search without tripping over newsgroup postings.. It uses most
of the spammy site techniques that the casino ad sites use. Google Groups
and Microsoft don't let robots reindex duplicate web copies of newsgroup
postings and do provide web based access So I disagree that it provides
a good service, because it and the sites he has sold that software make it
impossible for the average person to do a decent web search for Excel examples
and techniques. The alternative is to select a few sites to search but that is very
limiting. . It is strictly an advertising vehicle now.

It is rather unfortunate that ISPs no longer help their users sign up for newsgroups,
and give some netiquette tips, though the main tip about hanging around for two
weeks before posting is very passé since one can use Google to find out quickly
if it is the best newsgroup or not while finding out as much as they can before
posting their own question.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

They probably don't know that they're posting through a portal.

The owner of that forum gets credit for having a forum where people get
answers yet those answers are overwhelmingly supplied by people from
this/these newsgroups.

You can read the files but you have to read them from that site. You have to
click on the "View this thread" link.

I myself think having the abitily to post files *to a web forum* is a good
thing .. Of course, you take a chance when you open files from strangers!

Biff

You cannot post to a newsgroups and expect people to read a file
that is reserved to people who signup to post to newsgroups through
Excelforum, the regulars pretty much dislike the slowness of web based
newsreaders, looking at advertisements, or having newsgroups postings
indexed by Google as web pages. Not to mention the use of handles instead
of using real names (first and last). You would have to explain in
completely in
words what you want to do. Besides Google Groups Search will not
include
anything from outside of the text in the post so it is not helpful to
others who
search for answers..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

in message

I have several worksheets in a workbook that I would like to combine
onto one. All the column titles are the same, but the rows may
change.

Please see the attached example. I would like to know how to make the
"All tab" automatic, since the ranges may change from day to day.

The if possible I would like to make a consolidated tab based on a
criteria.

Thanks!!!


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4564 |
+-------------------------------------------------------------------+

--
Ninjafer
------------------------------------------------------------------------
Ninjafer's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24711
View this thread:
http://www.excelforum.com/showthread.php?threadid=528938

 

[David McRitchie]

As Peo said, I am not referring to you for your answer to the Original Poster, you provided
some textual insight into what your solution was and provided him with an example file
in a separate email (I presume).. Posting a question should take the same amount of
effort to make a question clear as those like yourself that answer a question.

But that does bring up another problem with the use of such sites and that is the lack
of threading of replies, so it looks like a reply is to the last reply to anything under
the original posting. You can see replies threaded in Google Groups like you can
see them threaded in a newsgroup reader.

 

[David McRitchie]

--

 

[David McRitchie]

There is a bit of a difference between asking a question from behind a mask,
and answering a question from behind a mask.

And you did somewhat describe your answer in words, but as not many people
can see the question anyway the answer is really pretty much not going to help
anyone but the original poster anyway, but we can see that they go an answer..

But you are shortchanging yourself using a name that people would not remember,
or recognize even if they actually knew you.