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?
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.
Install ASAPUtilities click hereFrom 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 "
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.
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 ?
© Copyright 2017 IDG UK. All Rights Reserved.