Fill a cell in Numbers based on a cell on another sheet
Is it possible to auto fill a cell in a Numbers worksheet to match a selection from a Pop-Up Menu in a cell on a corresponding worksheet in the same file?
iPad, iOS 10
Is it possible to auto fill a cell in a Numbers worksheet to match a selection from a Pop-Up Menu in a cell on a corresponding worksheet in the same file?
iPad, iOS 10
Yes, in the destination cell type = to call up the formula editor, then click the source cell in the other sheet, and "accept" the formula by hitting <return> or clicking the green check mark in the formula editor.
SG
Yes, in the destination cell type = to call up the formula editor, then click the source cell in the other sheet, and "accept" the formula by hitting <return> or clicking the green check mark in the formula editor.
SG
Thank you!
Fill a cell in Numbers based on a cell on another sheet