+ Reply to Thread
Results 1 to 2 of 2

Insert text in whole calendar column (day) using Information from other cells

  1. #1
    Registered User
    Join Date
    04-05-2019
    Location
    Zurich, Switzerland
    MS-Off Ver
    MS Office 2019
    Posts
    6

    Insert text in whole calendar column (day) using Information from other cells

    So my Calendar is almost done there's just one little thing i can't figure out.

    Let's say in Sheet1 I've got information in two different cells, a date(C10) and in the other cell what is going on, on this date(B10)
    Business Trip.PNG

    And in Sheet2 my calendar. Just a horizontal list of all business days in a year.
    What i've already achieved is that when i type in the Date in Sheet1(Events)the whole column gets highlighted. (Thanks to a post earlier)
    Highlighted Column.PNG
    Now my question is how can i automatically insert the Text from Sheet1 B10 into all Highlighted cells row 4-25?

    Can this be done with VBA or can i configure this in CF?

    Im thankful for any piece of advice

    Joel

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,810

    Re: Insert text in whole calendar column (day) using Information from other cells

    Can you post the code you use to highlight the column?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to insert and merge cells until all text in column is visible
    By teaker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2016, 02:13 PM
  2. Insert Rows in between cells of text in different column
    By king10001 in forum Excel General
    Replies: 2
    Last Post: 05-26-2015, 11:46 AM
  3. Grab Text associated with a date and insert it within a cell in a Calendar
    By PedroDel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2014, 11:53 AM
  4. [SOLVED] Pop up calendar to insert date in text box on user form
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-11-2013, 08:16 AM
  5. Fill in a calendar schedule with information based on dates in a column
    By matten7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2012, 10:10 AM
  6. how insert same text in empty cells in column (10000 rows)
    By bromptongadgets in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2005, 11:15 AM
  7. [SOLVED] How do place a column of date/time information into a calendar for
    By Linuxster in forum Excel General
    Replies: 0
    Last Post: 12-02-2005, 10:10 PM

Tags for this Thread

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