Merging Data from Multiple Tabs into 1 Master

[crankin]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to merge content from two seperate tabs (e.g name, address, etc.) into a single master content tab. How can I create a formula to merge the data from both tabs (using the same column structure) into one?

 

[CyberTaz]

Hi Crankin -

Ya got something against Copy/Cut - Paste ?

Seriously, unless there's some solid reason - which your description
suggests there isn't - that's the fastest, easiest & most accurate way.

Starting in the left-most cell of the first record (not the headings) in the
sheet you want to Cut/Copy from do the following:

Shift+Command+Right Arrow
Shift+Command+Down Arrow
Command+C (copy) or Command+X (cut)
Select the starting cell on the other sheet, Command+V

That's all there is to it unless you then need to sort the list.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Guest]

The problem with cut and paste is that the first 2 independent tabs are completed by church volunteers (not computer savvy) for a free community clinic and the Master tab would be for ministry staff review. My thoughts were to protect the master tab from individual edits. That way the volunteers can only edit the piece they're assigned. I agree cut & paste would be easiest if it were just me doing the spreadsheet but in this case there could be several people accessing this workbook and I'm just trying to minimize the need for an individual to go to tabs unnecessarily. If they don't go to the tab they can't effect the data on that tab. I know, long explanation. Basically... can it be done?