Welcome, Guest
Username: Password: Remember me

TOPIC: Copying a column of data from one sheet to another

Copying a column of data from one sheet to another 2 weeks 1 day ago #7842

  • CBuckley
  • CBuckley's Avatar
  • OFFLINE
  • Regular member
  • Posts: 19
I was wondering if it's possible to copy a column of data across from one sheet to another within the same gradebook? I set up a lovely page for all my writing data and thought the easiest way (other than filling it in manually) would be to download my markbook from iSams and import it from excel. The problem is now though that I have 2 separate sheets and can't figure out how to use the sheet I set up with the sheet containing data I've imported. I'd rather not modify the imported data to match the sheet I want to use as it took me a while to set it up that way. I hope that's clear?
The administrator has disabled public write access.

Copying a column of data from one sheet to another 2 weeks 1 day ago #7843

  • CBuckley
  • CBuckley's Avatar
  • OFFLINE
  • Regular member
  • Posts: 19
Erm so I've figured it out I think - I copied over one column from the imported markbook to the sheet I created. I then merged those 2 columns. This seemed to do what I wanted to but it'd be great to get confirmation that it's the correct way to go about it. :-)

This is the 2nd time I've posted and then worked something out - sorry!
The administrator has disabled public write access.

Copying a column of data from one sheet to another 2 weeks 1 day ago #7844

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2781
  • Thank you received: 492
It is ok CBuckley,
Here is an alternative copy/paste method. Can't say it is faster than yours though

Please take a moment to add or update your rating for iDoceo 4 so that we can continue working on it.
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
Last Edit: 2 weeks 1 day ago by bert.
The administrator has disabled public write access.
The following user(s) said Thank You: CBuckley
Time to create page: 0.104 seconds
21 SEP

Version 4.10.19 of iDoceo is now available!

A maintenance update with iOS12 support and some interesting additions

Read more

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more