Excel Issues
Closed
formulaflunkie
rizvisa1
- Posts
- 1
- Registration date
- Wednesday February 10, 2010
- Status
- Member
- Last seen
- February 11, 2010
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Excel Issues
- Transfer data from one excel worksheet to another automatically - Guide
- How to change date format in excel - Guide
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
1 reply
rizvisa1
Feb 11, 2010 at 07:05 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 11, 2010 at 07:05 AM
If N52 and A52 are in sheet1 and you want to put the value of cell N52 in sheet 2 in say cell b2
then you can write in cell b2 of sheet2 formula as
=IF(isnumber('Sheet1'!N52), 'Sheet1'!N52, "")
then you can write in cell b2 of sheet2 formula as
=IF(isnumber('Sheet1'!N52), 'Sheet1'!N52, "")