Related:
- Excel sheet to add conditions
- How to copy data from one excel sheet to another - Guide
- How to copy data to multiple worksheets in Excel - Guide
- Excel link to another sheet - Guide
- Vba add sheet - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
OK, so the syntax fo rIF is as follows:
=IF(logic_test,True, False)
So, your example would look like:
Then in a module:
So, the above solution will take the Data on Sheet10, cell A1, and place it into what ever cell has the If formula that calls the subroutine of place_value()
Have Fun!
=IF(logic_test,True, False)
So, your example would look like:
=IF(A1="X", place_value,"")
Then in a module:
sub place_value()
place_value=ThisWokbook.Worksheet("Sheet10").Cells(1,1).Value
end sub
So, the above solution will take the Data on Sheet10, cell A1, and place it into what ever cell has the If formula that calls the subroutine of place_value()
Have Fun!
