[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • Last Modified:

Excel 2010: how to automatically cumulate lines of two sheets in a third sheet

In Excel 2010 I have two sheets with data like this:

Sheet1:
NUMBER
one
three
six

Open in new window


Sheet2:
NUMBER
two
four
nine
ten

Open in new window


How can I have a third sheet that cumulates the lines of both the sheets?

Wanted sheet3:
NUMBER
one
two
three
four
six
nine
ten

Open in new window


Furthermore:

is it possible to have the third sheet auto-updated when sheet1 or sheet2 are modified?
is it possible to avoid/delete duplicates after the cumulation?
0
lucavilla
Asked:
lucavilla
  • 2
1 Solution
 
Sam Simon NasserCONSULTANT/DIRECTORCommented:
regarding third question, yes. in 3rd sheet use sheet1!cellnumber
in sheet 1 and 2, are number (one, two, ...) are numbers (1,2, ...) or text as you wrote?
0
 
lucavillaAuthor Commented:
they're all text (words)...
0
 
5teveoCommented:
I made quick and dirty macro and tied to button...

see macro - I added sort just incase numbers may be used... Just remove sort statement

Macro collect Sheet1 data then stacks Sheet2 data into Sheet3 and then remove duplicates.
EE-20130614-MergeColumnsUnduplic.xlsm
0
 
lucavillaAuthor Commented:
Impressive, thanks!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now