Results 1 to 1 of 1

Insert comments using data from cells in variable, named ranges

Threaded View

horariatersenha Insert comments using data... 05-13-2014, 04:22 PM
  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    3

    Insert comments using data from cells in variable, named ranges

    I'm attempting to build a report which takes data that includes dates, names and events with start/end times and inserts a comment onto another sheet which contains a schedule which corresponds with the dates/names.

    I have code for inserting comments but where I'm stuck is figuring out the best way to have Excel store all event data (events + start/end times) per day, per name and have the names and dates matched on the calendar sheet so the comments are inserted in the correct cell.

    I've been reading about and trying to use named ranges and variable arrays but am looking for any additional help you fine folks may be able to provide.

    The end result of what I'm trying to achieve is to have the calendar look like this: http://i.imgur.com/55z4Ppi.png

    Thanks!
    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. Multiple named ranges with variable lengths set by user via single cell value
    By devcow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2012, 01:12 AM
  2. Replies: 0
    Last Post: 10-15-2012, 07:24 AM
  3. Macro to insert comments and get data from cells
    By Picco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2012, 03:28 AM
  4. variable in to input data into variable named sheet and if does not exist create
    By rwhidden in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-30-2011, 12:08 AM
  5. Copy data in named ranges to a newer version of the same template to identical ranges
    By handstand in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 10:51 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