Merge, update, and add only new entries into a list from other she
 

I have seen a post here rather identical to my question. Allow me to elaborate:

Generic information:
- I will be getting one new sheet with data for every month that passes,
they are thus named as months.
- Sheet1, labelled "overview", has a summary of all subsequent sheets.

Specific information:
- All subsequent sheets contain a row of headings, and then a list of 100
text entries.
- The overview sheet is to display a complete list of all entries in
subsequent sheets, but these entries will inevitably repeat themselves in
some cases.
- Thus, what I need, is for "overview" to run a formula in each cell of
column A which will check for new/duplicate entries in subsequent sheets, and
then return the text of any of those sheets if that entry is not a duplicate
already found in the "overview" list.

This has been run by alot of people, so this would be my last resort. I am
novice to advanced user with Excel, and am really just wondering if I will
need to write up a small piece of VB code to solve this or if Excel itself
has formulas/code which will solve this mind-boggler for me.

You could use an Advanced Filter to filter the unique entries on the
overview sheet to a new sheet. There are instructions in Excel's Help,
and he

http://www.contextures.com/xladvfilter01.html

Chab wrote:
I have seen a post here rather identical to my question. Allow me to elaborate:

Generic information:
- I will be getting one new sheet with data for every month that passes,
they are thus named as months.
- Sheet1, labelled "overview", has a summary of all subsequent sheets.

Specific information:
- All subsequent sheets contain a row of headings, and then a list of 100
text entries.
- The overview sheet is to display a complete list of all entries in
subsequent sheets, but these entries will inevitably repeat themselves in
some cases.
- Thus, what I need, is for "overview" to run a formula in each cell of
column A which will check for new/duplicate entries in subsequent sheets, and
then return the text of any of those sheets if that entry is not a duplicate
already found in the "overview" list.

This has been run by alot of people, so this would be my last resort. I am
novice to advanced user with Excel, and am really just wondering if I will
need to write up a small piece of VB code to solve this or if Excel itself
has formulas/code which will solve this mind-boggler for me.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html