I have several sheets in Excel, i.e. Sheet 1, Sheet 2 and Sheet 3. I wanted that A1 cell from Sheet 1 to copy any value that has both A1 cell from Sheet2 and A1 cell from Sheet 3.
Or this if is possible:
- If A1 cell from Sheet2 has any value to insert "text1" into A1 cell from Sheet 1 and if A1 cell from Sheet3 has any value to insert "text2" into A1 cell from Sheet 1.
In any empty cell in any sheet
type this formula
- Excel - Copy info from several cells into one cell
- Excel - delete info from a cell found in anot ✓ - Forum - Excel
- How to move info from one cell to another in excel - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Excel return value if another cell contains text ✓ - Forum - Excel
- Excel vba filter based on cell value ✓ - Forum - Excel