Solved

Creating a Master table out of several smaller tables

Posted on 2013-01-21
2
137 Views
Last Modified: 2013-02-14
Hello all,

We are trying to great one giant table for all of our partners, we had each partner fill out this table in their own separate sheet and now we want to compile the list. There has to be an easy way of doing this besides copying and pasting all of them, something that would update the master list if a line is added in a table in one of the sheets?
0
Comment
Question by:karaflanagan
2 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 400 total points
ID: 38803795
0
 

Author Comment

by:karaflanagan
ID: 38832944
Are there any ways that anyone knows of how to do this without using VBA?
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now