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 help would be great.
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?
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.
- HOW, in the formulas you've tried, do you refer to those other tabs, for starters?
