Forum Discussion
Creating a Master Tab for multiple tabs
I am looking to get a formula that will auto insert "X" if the same cell from any other tabs has "Y" on it. Not sure what formula to use. The ones that I have tried all come back with errors. Any he...
You could help us help you by giving some more specifics:
- HOW, in the formulas you've tried, do you refer to those other tabs, for starters?
- Do you use INDIRECT? Something else?
- While we're on the subject of other tabs, How many are there, and WHY do you have multiple tabs? (it's possible that a re-design of the overall workbook could be in order)
- WHAT are the formulas you've tried?
- WHAT error messages are you receiving?
Is it possible, without violating confidentiality or privileged data, for you to post the workbook in question, or a mockup of it, either here in this forum or, that failing, on OneDrive or GoogleDrive?
mathetesI have used the if, iferror, vlookup formulas and keep getting a value error.
There is no confidentiality or privileged data, but not sure how to post it here.
INDIRECT would be a better function for referring to the same cell in a set of tabs. Here's a reference.
https://exceljet.net/excel-functions/excel-indirect-function
Notice, I suggested as an alternative to posting here that you post a copy on OneDrive or in GoogleDrive...just post a link here.
- thanks!
Here is the google doc link...
https://drive.google.com/drive/u/0/my-drive
file name is Report Tracker Template- I'm sorry but that link just takes me to my-drive, i.e., MY drive. Not your drive. Nor, certainly, your file. All I see are the files in my own Google Drive.
You need to use the share my file (whatever it's called) from within Google Drive. Or, if it's an Excel sheet to begin with and you have OneDrive, that would work more effectively. But there too you need to share the access to the actual file, not just a drive.