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
- Excel conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel vba copy row if cell value matches ✓ - Forum - Office Software
- Excel duplicate rows based on cell value ✓ - Forum - Excel
- Excel create rows based on cell value - Forum - Excel