Copy excel mac os sheet
The issue relates to both existing files that used to work just fine, and to new files that I create. I've already uninstalled and reinstalled the latest Excel with no luck. drag file into ical and it should import all data.Help! The names on my sheet tabs at the bottom of my spread sheets have disappeared - I can see the sheet tabs and select them as normal, but I can't see the names so it's impossible to know which tab is which. ics file and highlight all text and edit and paste over it.Ĭlose file and answer yes to any pop up, your saved file should be in word format with. got to end of doc and replace the last line which should be the word break with END:VCALENDARĮdit Select all and copy to clip board. In replace type ^b and in replace with box type the word break and hit the space bar once, this is important. In new Doc go to edit replace to remove page breaks and do the following Now go to merge and click on merge to new document only two other columns needed description and unique idĢ.create a single event in ical and drag to your desk top and open with word.Ĥ.find unique ID "UID:C8E07A3D-2D99-4BC3-AEA5-DD87162B8C300" and copy to excel column put any number at end of ID and add 1 to next column C8E07A3D-2D99-4BC3-AEA5-DD87162B8C301 create a uid for every date by dragging down from two created,ĥ In word go to tools and open Data merge managerī: Get Data Open Data source which is your excel fileĭrag date to this field and replase date in front of T with merge field DTEND TZID=Europe/Dublin:«sdate»T010000 prepare your data in Excel create column of dates and custom format colum yyyymmdd no forwad slash. To sync your shift roster from excel to ical i will go through all the steps because usually people on shift will not normally use word form letters etc.ġ. If you need other iCal lines, make a dummy event, look for the appropriate lines in the copied event, and replace the data with a mergefield title for your Excel data. Here's what the key Word Form Letter lines with my mergefield names look like:ĭTSTART TZID=US/Eastern:«yymmdd»T«starthhmmss»ĭTEND TZID=US/Eastern:«yymmdd»T«endhhmmss» If you're familiar with mail merge in Word, this all isn't difficult. It will open iCal and import the events into the calendar you specify. Click on the iCal calendar file you've just updated. Select all and copy the lines back into the original iCal event file you created in step 1., replacing the template lines you highlighted in step 2 and save.Ĩ. Globally replace the section breaks with nulls to remove them. Do a Merge to New Document (test this with just a few merge records first at this point). If you use calendar notes for the events, replace the text in the DESCRIPTION: line with your mergefield column names for note lines(multiple lines are separated by "\n").ħ. Replace the event description in the SUMMARY: line with your mergefield for event description.Ħ.
Do the same for the DTEND line for end date and time.ĥ. Replace the time (after the "T" character) with your mergefield name for the start hhmmss. In the Word Form Letter document, look for the DTSTART line and replace the date (before the "T" character) with the Word mergefield name you've used for the start yyyymmdd. Copy your Excel worksheet data into a new Word document which will be your Data Source for your mail merge.Ĥ. Use appropriate unique column header names.Ĥ. In your Excel worksheet of events, create columns for start dates in yyyymmdd format, start times in hhmmss format (24-hour clock) and similarly for end dates and end times. Use Tools|Data Merge Manager to Create a Form Letter from this new document.ģ. Copy the lines between the BEGIN:VTIMEZONE line and the next to last line END:VEVENT into a new document. This file shows you the iCal standard lines required to describe an event.Ģ. Drag any iCal event from your calendar onto your desktop and open it in Word. Thanks to a hint I found elsewhere, I managed to do what you want by creating a Word mail merge list from my Excel file event entries in iCal format.