 |
 | 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 / July 2006Repeating Cell Entries Between Sheets
I have eight sheets in a workbook and want to repeat an entry in a cell from one sheet to another. For example in sheet/cell Carl-Summary L3 I type the figure 60. In sheet Main Summary I want this figure to repeat in cell C6 and so on. Can anyone give me the formula for this. I've tried all I know. TIA Ed >I have eight sheets in a workbook and want to repeat an entry in a cell >from one sheet to another. [quoted text clipped - 7 lines] > > Ed Hi Ed One way: In Main Summary C6 this formula ='Carl-Summary'!L3 the hyphen makes it necessary to add single quotes around the sheet name. To avoid this, use underscore _ instead of hyphen - =Carl_Summary!L3  SignatureBest regards Leo Heuser Followup to newsgroup only please. Thanks, Leo. I tried that and - mysteriously - I get what looks like a date 19/02/1900. The figure typed in L3 is 50. It is not a formulated number but merely typed in. Ed >>I have eight sheets in a workbook and want to repeat an entry in a cell >>from one sheet to another. [quoted text clipped - 22 lines] > > =Carl_Summary!L3 Actually, Leo, I have been trying this as I don't want a load of zeros. =IF('CARL-Summary'!L3=0," ",'CARL-Summary'!L3) and I got the same result - that peculiar date. Well, now I know why... The formatting had somehow switched to "Date". All is now okay. Thanks for your patience! Ed > Thanks, Leo. I tried that and - mysteriously - I get what looks like a > date 19/02/1900. The figure typed in L3 is 50. It is not a formulated [quoted text clipped - 28 lines] >> >> =Carl_Summary!L3 > Actually, Leo, I have been trying this as I don't want a load of zeros. > =IF('CARL-Summary'!L3=0," ",'CARL-Summary'!L3) and I got the same [quoted text clipped - 12 lines] >> >> Ed You're welcome Ed. The first day Excel can handle is 01/01/1900. When you enter 50 in a cell, that is formatted as date, you will get day number 50, which is 19/02/1900 (50 = 31 (for January) + 19 (for February)) Thanks for the feedback :-) Leo How do you know all this.... Do you teach Excel, or something? Ed >> Actually, Leo, I have been trying this as I don't want a load of zeros. >> =IF('CARL-Summary'!L3=0," ",'CARL-Summary'!L3) and I got the same [quoted text clipped - 22 lines] > > Leo > How do you know all this.... Great interest in Excel and a lot of hard work :-) > Do you teach Excel, or something? I'm retired now, but I taught Excel for many years and did a fair amount of development in Excel too. Regards Leo Heuser I'm retired also, but have only been introduced to Excel for about a year. You are clearly a very useful person to know and it's encouraging to know you're around. Best wishes, Ed. >> How do you know all this.... > Great interest in Excel and a lot of hard work :-) [quoted text clipped - 5 lines] > Regards > Leo Heuser > I'm retired also, but have only been introduced to Excel for about a year. > You are clearly a very useful person to know and it's encouraging to know [quoted text clipped - 3 lines] > > Ed. Thanks for the nice words, Ed! Normally I help in the Danish Excel group, but right now everyone seems to be on vacation, so I thought I would pay a short visit to the English groups :-) Leo Just so I know where to find you :) Ed >> I'm retired also, but have only been introduced to Excel for about a >> year. [quoted text clipped - 11 lines] > > Leo
|
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.