Excel? Copying data from many sheets to a master

  ShorN 23:24 15 Nov 2005
Locked

Hello,

Just looking for some help with Excel.

Im looking at the easiest way to copy data from multiple workbooks into a master workbook.

Basically I shall have a master spreadsheet, which will contain (for example 100) questions, I will then email that to 10 people.

Person one will complete questions 1-10, person two will complete 11-20 and so on.

They will then email their sheets back to be so i will have 10 sheets that need to be collated into one.

is there anyway of automating something like this?

  PaulB2005 07:22 16 Nov 2005

Copy and Paste? In the time it would take to setup anything more compicated you might as well just copy and paste the data into one sheet.

  VoG II 12:56 16 Nov 2005

Install ASAPUtilities click here

From the ASAP Menu, Sheets > Summarize rows or columns from several sheets

"This utility will combine the selected columns of each sheet into a new sheet (summary).
Usage:
Select the desired sheets.
Start this utility, then select the rows(s) you wish to summarize "

  ShorN 23:22 16 Nov 2005

Thanks for the link vog, thats a pretty nifty tool!
unfortunatley its a pc at work that wont allow installing anything, so looks like im stuck with copy and pasting!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?