Hi everyone, new to the community, I’d be v. grateful for any advice on this head-scratcher.  Not sure if I’m asking the question in the right way so please ask if anything unclear.

I’m on a Mac using Office 365.  I have a multi-tabbed workbook that is used to record print specifications for different pieces of corporate collateral. 

The first sheet is a summary/aggregator of information from all other sheets to enable easy cross-checking and comparison.  Reference images and numerical/text data relating to each item are entered to individual sheets (with tab name as the item name) and I’d like to find a way to dynamically pull into the summary sheet key images and data from individual sheets with the ability to add or remove sheets in future and have the summary sheet update automatically. 

I know how to add manual links to the data sets, but if a sheet is added, I have to go back to the summary and add more manual links for the corresponding row to be updated.  I’d like to find a way for this to happen automatically.

SUMMARY SHEET SET-UP

Tab name = AA_SUMMARY with the Name Box entry as ‘INDEX’Column A = numbers 1-100 on individual rows, starting row 5 (to allow for sheet title etc in rows 1-4)Column B = empty (aesthetic spacer)Column C = contains a list of all the tab/sheet names, pulled in via  =INDEX(SheetNames,A5) type formula.  This relies on having the numbers in column A to work, I believe, as without the numbers, the index runs along the row, and I want it to run down the column.Column D = hyperlink to the individual sheet named in C via  =HYPERLINK(“#'”&B2&”‘!A1″,”Go To Sheet”).  Does double duty as navigation and also is what I’ve been using to direct formula to relevant sheet (see lower down). Columns E+ = these are the cells I want to populate with data from the other worksheets.  All columns have a header which corresponds to a category of information present in the other worksheets.  The idea being that if you look along a row, you get all the key information for that sheet – like this this, where the text in red italics automatically pulls in – regardless of whether you add sheets or remove sheets.

    Ref imagecategory 1category 2category 31 NAME OF WORKSHEET 1Go to sheet[image]data 1data 2data 3 2 NAME OF WORKSHEET 2Go to sheet[image]data 1data 2data 3

This set-up enables sheet names to be added or removed dynamically if new ones are added to the work book, or old ones deleted.

DATA-ENTRY SHEET SET-UP

Tab name = individual name relevant to the item, I’ve not added a named range via Name BoxRows 1-3 = sheet headings Row 5, across columns A-H = reference image inserted in-cellRow 6 = blank (aesthetic spacer)Row 7, columns A-H = merged containing the item name which is pulled in from the tab name via =TEXTAFTER(CELL(“filename”,A1),”]”)Row 8, columns A-H = individual category headers which match the category 1 / category 2 (etc) headers on the summary sheetRow 9, columns A-H = empty cells where relevant data is entered

Image pulled in here via ‘insert image in-cell)

 Item:Name of item pulled in here via =TEXTAFTER(CELL(“filename”,A1),”]”)Category 1Category 2Category 3Category 4Category 5Category 6Category 7Category 8enter data 1enter data 2enter data 3enter data 4enter data 5enter data 6enter data 7enter data 8

(sorry for odd looking table – the editor won’t allow me to merge the image, spacer and item cells at full width across the lower columns.)

THE PROBLEM

I’m hitting a wall trying to find a formula which knows to look at the hyperlink sheet destination, go to that sheet and pull in info from cells 9A > 9H. 

If I manually add:  = and click the hyperlink cell to pull in the sheet name, then navigate to that sheet and click the relevant cell in that sheet, (eg: formula looks like: =LETTERHEAD!A9  ) it does return the correct data to that cell in the summary.  But if then copy that formula to the following rows, it just pulls in the original sheet name, rather than the one relevant to that row and won’t dynamically update itself.

So the issue seems to be finding a formula that instructs to look left to the hyperlink for each row automatically, then reference the relevant cell in the destination sheet.

I hope that makes sense, and any advice v. gratefully received. 

Thanks in advance!

Soph.

​  Hi everyone, new to the community, I’d be v. grateful for any advice on this head-scratcher.  Not sure if I’m asking the question in the right way so please ask if anything unclear.I’m on a Mac using Office 365.  I have a multi-tabbed workbook that is used to record print specifications for different pieces of corporate collateral.  The first sheet is a summary/aggregator of information from all other sheets to enable easy cross-checking and comparison.  Reference images and numerical/text data relating to each item are entered to individual sheets (with tab name as the item name) and I’d like to find a way to dynamically pull into the summary sheet key images and data from individual sheets with the ability to add or remove sheets in future and have the summary sheet update automatically.  I know how to add manual links to the data sets, but if a sheet is added, I have to go back to the summary and add more manual links for the corresponding row to be updated.  I’d like to find a way for this to happen automatically.SUMMARY SHEET SET-UPTab name = AA_SUMMARY with the Name Box entry as ‘INDEX’Column A = numbers 1-100 on individual rows, starting row 5 (to allow for sheet title etc in rows 1-4)Column B = empty (aesthetic spacer)Column C = contains a list of all the tab/sheet names, pulled in via  =INDEX(SheetNames,A5) type formula.  This relies on having the numbers in column A to work, I believe, as without the numbers, the index runs along the row, and I want it to run down the column.Column D = hyperlink to the individual sheet named in C via  =HYPERLINK(“#'”&B2&”‘!A1″,”Go To Sheet”).  Does double duty as navigation and also is what I’ve been using to direct formula to relevant sheet (see lower down). Columns E+ = these are the cells I want to populate with data from the other worksheets.  All columns have a header which corresponds to a category of information present in the other worksheets.  The idea being that if you look along a row, you get all the key information for that sheet – like this this, where the text in red italics automatically pulls in – regardless of whether you add sheets or remove sheets.     Ref imagecategory 1category 2category 31 NAME OF WORKSHEET 1Go to sheet[image]data 1data 2data 3 2 NAME OF WORKSHEET 2Go to sheet[image]data 1data 2data 3 This set-up enables sheet names to be added or removed dynamically if new ones are added to the work book, or old ones deleted. DATA-ENTRY SHEET SET-UPTab name = individual name relevant to the item, I’ve not added a named range via Name BoxRows 1-3 = sheet headings Row 5, across columns A-H = reference image inserted in-cellRow 6 = blank (aesthetic spacer)Row 7, columns A-H = merged containing the item name which is pulled in from the tab name via =TEXTAFTER(CELL(“filename”,A1),”]”)Row 8, columns A-H = individual category headers which match the category 1 / category 2 (etc) headers on the summary sheetRow 9, columns A-H = empty cells where relevant data is entered   Image pulled in here via ‘insert image in-cell)   Item:Name of item pulled in here via =TEXTAFTER(CELL(“filename”,A1),”]”)Category 1Category 2Category 3Category 4Category 5Category 6Category 7Category 8enter data 1enter data 2enter data 3enter data 4enter data 5enter data 6enter data 7enter data 8 (sorry for odd looking table – the editor won’t allow me to merge the image, spacer and item cells at full width across the lower columns.) THE PROBLEMI’m hitting a wall trying to find a formula which knows to look at the hyperlink sheet destination, go to that sheet and pull in info from cells 9A > 9H. If I manually add:  = and click the hyperlink cell to pull in the sheet name, then navigate to that sheet and click the relevant cell in that sheet, (eg: formula looks like: =LETTERHEAD!A9  ) it does return the correct data to that cell in the summary.  But if then copy that formula to the following rows, it just pulls in the original sheet name, rather than the one relevant to that row and won’t dynamically update itself. So the issue seems to be finding a formula that instructs to look left to the hyperlink for each row automatically, then reference the relevant cell in the destination sheet. I hope that makes sense, and any advice v. gratefully received. Thanks in advance!Soph.   Read More

​

My flagged emails no longer show up in To Do. I’ve tried flagging emails on Windows, iPhone, iPad and the web and none of them send the message to To Do. MS To Do shows the flagged email list and tells me that “Messages you flag will show up as tasks here” but this isn’t true.

I tried turning flagged emails off in the To Do settings, then back on. I tried restarting the machine. Problem persists.

My company moved to Office 365 about the same time that New Outlook came out, I suspect one of these things broke my ability to flag an email in outlook and have it show up in MS To Do. I liked this functionality as I could process emails by flagging them and then archiving them on my iPhone or iPad or wherever and they would reliably show up on my To Do list.

Anyone have any ideas what may have broken this functionality?

Thanks,

Michael

​My flagged emails no longer show up in To Do. I’ve tried flagging emails on Windows, iPhone, iPad and the web and none of them send the message to To Do. MS To Do shows the flagged email list and tells me that “Messages you flag will show up as tasks here” but this isn’t true. I tried turning flagged emails off in the To Do settings, then back on. I tried restarting the machine. Problem persists. My company moved to Office 365 about the same time that New Outlook came out, I suspect one of these things broke my ability to flag an email in outlook and have it show up in MS To Do. I liked this functionality as I could process emails by flagging them and then archiving them on my iPhone or iPad or wherever and they would reliably show up on my To Do list. Anyone have any ideas what may have broken this functionality? Thanks,Michael  Read More

​

I just downloaded the latest 365 updates, but the new regexextract function is not working.  I just get #NAME?      Excel version 2406, build 17726.20078.  June 17, 2024.  I am on a Windows 10 machine, but I don’t believe that should matter.  

​I just downloaded the latest 365 updates, but the new regexextract function is not working.  I just get #NAME?      Excel version 2406, build 17726.20078.  June 17, 2024.  I am on a Windows 10 machine, but I don’t believe that should matter.    Read More

​

Quick-Books Sync Manager not working – keeps freezing and failing to sync my data. How can I fix this issue?

​Quick-Books Sync Manager not working – keeps freezing and failing to sync my data. How can I fix this issue?  Read More

​

I’m experiencing Quick-Books Error 193 when trying to access my company file. How can I resolve this issue and prevent it from happening again?

​I’m experiencing Quick-Books Error 193 when trying to access my company file. How can I resolve this issue and prevent it from happening again?  Read More

​

Hi folks,

I setup Microsoft Authenticator as the 2FA on my work account on a phone which was destroyed.  I’m trying to setup the authenticator on my new phone, but whenever I try to sign into the account, the only MFA option I’m given is to verify using the authenticator which is no longer accessible (I’m the only user on the account as well).

I’ve tried resetting the password, sending email to my alternate email address, getting microsoft to call my office number, and just keep ending up at the same spot.  Is there an option I’ve missed which says “I no longer have access to the authenticator app”?  Is there ANY other way I can verify my identity and regain access to the account?

Thanks

​Hi folks, I setup Microsoft Authenticator as the 2FA on my work account on a phone which was destroyed.  I’m trying to setup the authenticator on my new phone, but whenever I try to sign into the account, the only MFA option I’m given is to verify using the authenticator which is no longer accessible (I’m the only user on the account as well). I’ve tried resetting the password, sending email to my alternate email address, getting microsoft to call my office number, and just keep ending up at the same spot.  Is there an option I’ve missed which says “I no longer have access to the authenticator app”?  Is there ANY other way I can verify my identity and regain access to the account? Thanks  Read More

​

Hi,
We are an IT software development firm seeking to become a Microsoft Solution Partner. We are looking for guidance on the requirements and the necessary steps to start this process. Any assistance from experienced professionals in this area would be greatly appreciated.

​Hi,We are an IT software development firm seeking to become a Microsoft Solution Partner. We are looking for guidance on the requirements and the necessary steps to start this process. Any assistance from experienced professionals in this area would be greatly appreciated.  Read More

​

Hello Microsoft Tech Community,

I am reaching out in hopes of connecting with someone from the Microsoft Learn Security Team. Unfortunately, there has been a misunderstanding during one of my exams, resulting in a ban on my Microsoft Certification Profile from scheduling or taking any further certification exams.

I have made several appeals for the removal of the ban but have not yet received a response from the Microsoft Learn Security Team. The certification I am pursuing is critical for my professional development and career advancement.

I kindly request assistance from the community or any team member who can guide me on how to resolve this issue. Your help in lifting this ban would be immensely appreciated.

Thank you for your attention to this matter.

​Hello Microsoft Tech Community, I am reaching out in hopes of connecting with someone from the Microsoft Learn Security Team. Unfortunately, there has been a misunderstanding during one of my exams, resulting in a ban on my Microsoft Certification Profile from scheduling or taking any further certification exams. I have made several appeals for the removal of the ban but have not yet received a response from the Microsoft Learn Security Team. The certification I am pursuing is critical for my professional development and career advancement. I kindly request assistance from the community or any team member who can guide me on how to resolve this issue. Your help in lifting this ban would be immensely appreciated. Thank you for your attention to this matter.  Read More

​

I have a question regarding the access of M365 to local and network files and what other options I might have.

I’ve noticed that Copilot for Teams has access to OneDrive, but Copilot for Word, Excel, and PowerPoint, for example, can only access SharePoint links. Can you confirm this?

I have also found that Copilot does not have access to local files or network files.

I once heard from an IT service provider that Microsoft is working on a copilot that would have access to local/network files. Is this true?

Since the current Copilot for M365 does not have access to local/network files, I would like to ask the following question: Is there another AI tool from a third-party provider that has access to local files and network files?

​I have a question regarding the access of M365 to local and network files and what other options I might have.I’ve noticed that Copilot for Teams has access to OneDrive, but Copilot for Word, Excel, and PowerPoint, for example, can only access SharePoint links. Can you confirm this?I have also found that Copilot does not have access to local files or network files.I once heard from an IT service provider that Microsoft is working on a copilot that would have access to local/network files. Is this true?Since the current Copilot for M365 does not have access to local/network files, I would like to ask the following question: Is there another AI tool from a third-party provider that has access to local files and network files?  Read More

​