Results 1 to 4 of 4

insert rows and insert text in the cells in the inserted row

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2012
    Location
    MN
    MS-Off Ver
    Excel 2010
    Posts
    50

    insert rows and insert text in the cells in the inserted row

    I am trying to improve my experience creating quizzes in a online gradebook course management software called D2L. This software has a CSV template for importing quizzes. The template has many types of questions, with specific rows and text for each question type. I only use three question types. I am fairly certain that if I can get started with a macro for one of the types, I can figure out the rest. The way I currently do this is when I want to add a question to the quiz, I copy the rows including two blank lines at the bottom from my template and then Insert Copied Cells where I want the question to appear. That works fine, but I know it can be faster.

    I imagine my workflow will be to select the row where I want to insert these populated rows, and then run the macro.

    This is a screen shot of the data in Excel.
    6AD0513F-F71F-4378-998E-EAAEB72A8C22_4_5005_c.jpeg

    This is the data in CSV form:
    NewQuestion,MC,,,
    QuestionText,This is the question text for MC1,,,
    Option,0,This is the correct answer,,
    Option,0,This is incorrect answer 1,,
    Option,0,This is incorrect answer 2,,
    Option,0,This is partially correct,,
    Feedback,This is the feedback text,,,
    ,,,,
    ,,,,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to insert different number of rows and drag values from the row before inserted?
    By Ekaterina26 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-08-2016, 10:31 AM
  2. [SOLVED] Insert Row and Add Text to new cell of Inserted Row
    By Hood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2016, 07:51 AM
  3. [SOLVED] VBA codes to insert the rows and copy the first entire row text and insert sheet
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2013, 05:05 AM
  4. Replies: 0
    Last Post: 05-10-2013, 12:04 PM
  5. Automatically Insert Columns as a Result of Inserted Rows
    By The Exceller in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-01-2012, 09:35 AM
  6. Insert row, modify original & inserted rows
    By 1cor1_27 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2011, 05:00 PM
  7. [SOLVED] automatically insert formula when new rows are inserted
    By BLUEJAY in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-27-2006, 05:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1