 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008formulas between worksheets
could any body tell me if it is possible to create a formula that allows you for example to input a number in worksheet 1 and for that number to automatically appear in worksheet 2? This formula on any sheet would make the cell equal to Sheet 1 A1 =Sheet1!A1 Mike > could any body tell me if it is possible to create a formula that allows you > for example to input a number in worksheet 1 and for that number to > automatically appear in worksheet 2? thankyou so much > This formula on any sheet would make the cell equal to Sheet 1 A1 > [quoted text clipped - 5 lines] > > for example to input a number in worksheet 1 and for that number to > > automatically appear in worksheet 2? If Sheet1 A1 is blank, the formula will return a 0 To trap for that..........=IF(Sheet1!A1="","",Sheet1!A1) Gord Dibben MS Excel MVP >thankyou so much > [quoted text clipped - 7 lines] >> > for example to input a number in worksheet 1 and for that number to >> > automatically appear in worksheet 2?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.