+ Reply to Thread
Results 1 to 2 of 2

Passing concatenated text into a calendar

  1. #1
    Registered User
    Join Date
    03-15-2017
    Location
    Atlanta
    MS-Off Ver
    2013
    Posts
    3

    Passing concatenated text into a calendar

    I am stumped. My skills aren't advanced though so that isn't hard. Basically I have a sheet with events that have stages with designated intervals. On day for stage 1, four days for stage 2, etc. I have a table set up that auto calculates due dates based on the initiation date. I want these deadlines to auto populate into the corresponding calendar cells. And here's the rub. I would like for it to say "Title Stage" in the date. So like "Event 1 Stage 2". I was hoping to pull the event title from column A and the stage from row 1. I may be approaching this all wrong because I cant find something that works for me. Anyone have a direction or formula combination they recommend I look at? I have attached the calendar I am working with.

    The end goal is to have a workbook that I can put an event title and initiation date into and the deadlines auto calculate and the calendar auto populates with deadlines.
    Attached Files Attached Files
    Last edited by IDvsEGO; 01-17-2019 at 03:30 PM.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Passing concatenated text into a calendar

    To be honest, I am not sure Excel is really the best tool for this type of thing, and the setup will make things challenging (try to avoid merged cells for example)... but, regardless, attached shows you how you *could* do it -- I have only populated Jan & Feb, and the practicalities of this approach will diminish the more data you end up with (obviously).

    The attached basically has the following calc replicated in each cell below the individual dates:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Note, when updating remaining months, the above formulae can be copied and pasted (as formula) over remaining months / cells, no changes are required (simply copy & paste job).
    Attached Files Attached Files

+ 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. Convert Concatenated Text to Formula
    By TristanRicAlindogan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-13-2013, 12:38 AM
  2. vba to Match concatenated values in concatenated columns
    By bjurick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2012, 03:45 PM
  3. Format certain phrases of concatenated text
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2011, 11:53 AM
  4. Convert Concatenated Text to Formula
    By locyip in forum Excel General
    Replies: 7
    Last Post: 02-04-2010, 03:39 PM
  5. bold certain concatenated text
    By HuskerBronco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2009, 05:05 AM
  6. How to format concatenated text?
    By bristly in forum Excel General
    Replies: 2
    Last Post: 04-01-2008, 06:30 AM
  7. [SOLVED] Use concatenated text as name in formulas
    By Apollo63 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2006, 11:10 AM
  8. concatenated text to formula
    By Bill Elerding in forum Excel General
    Replies: 6
    Last Post: 05-04-2005, 09:06 PM

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