Formula Solution with a Macro?

[vbeckum]

I have a long formula from excel 2007. I need to shorten it due to reaching maximum charecters. Can someone please help me, thank you. It is part of an excel sheet that goes to my jobs break schedule.

='C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!I6="b" "5:00AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!J6="b" "5:15AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!K6="b" "5:30AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!L6="b" "5:45AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!M6="b" "6:00AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!N6="b" "6:15AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!O6="b" "6:30AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!P6="b" "6:45AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!Q6="b" "7:00AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!R6="b" "7:15AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!S6="b" "7:30AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!T6="b" "7:45AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!U6="b" "8:00AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!V6="b" "8:15AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!W6="b" "8:30AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!X6="b" "8:45AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!Y6="b" "9:00AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!Z6="b" "9:15AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AA6="b" "9:30AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AB6="b" "9:45AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AC6="b" "10:00AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AD6="b" "10:15AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AE6="b" "10:30AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AF6="b" "10:45AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AG6="b" "11:00AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AH6="b" "11:15AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AI6="b" "11:30AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AJ6="b" "11:45AM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AK6="b" "12:00PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AL6="b" "12:15PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AM6="b" "12:30PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AN6="b" "12:45PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AO6="b" "1:00PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AP6="b" "1:15PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AQ6="b" "1:30PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AR6="b" "1:45PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AS6="b" "2:00PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AT6="b" "2:15PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AU6="b" "2:30PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AV6="b" "2:45PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AW6="b" "3:00PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AX6="b" "3:15PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AY6="b" "3:30PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!AZ6="b" "3:45PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BA6="b" "4:00PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BB6="b" "4:15PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BC6="b" "4:30PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BD6="b" "4:45PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BE6="b" "5:00PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BF6="b" "5:15PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BG6="b" "5:30PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BH6="b" "5:45PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BI6="b" "6:00PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BJ6="b" "6:15PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!BK6="b" "6:30PM" 'C:\Users\vbeckum\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\BG1VHUR2\[Coverage 5-12.xlsx]Thursday'!

 

[Herbiec09]

Hi,

It would seem that your spreadsheet has been saved from an outlook download,i.e. emailed version. If this the case, you can edit links and repoint the links to your jobs break schedule, this should create a much shorter formula.

Hope this helps

Herbz