I want to combine data from several worksheets onto one 'master' worksheet automatically. The 'topics' in each worksheet are mostly the same but not identical. An example of what I want to do is below. How do I make excel do this? There are over 40,000 lines total when all worksheets are added together.
worksheet a:
taco tuesday 598
glass half full 61
empty container 36
lazy susan 1888
snazzy betty 89
worksheet b:
empty container 877
lazy susan 941
taco tuesday 866
glass half full 799
excited elephant 5
worksheet c:
lazy susan 2500
taco tuesday 1782
glass half full 1900
empty container 645
snazzy betty 966
I want to end up with a master worksheet that looks like this and does it automatically: (note: imagine that the name and then each number are in its own separate column, this forum removes extra spaces)
name a b c
lazy susan 1888 941 2500
glass half full 61 799 1900
empty container 36 877 645
taco Tuesday 598 866 1782
snazzy betty 89 empty 966
excited elephant empty empty 5
Bookmarks