 |
 | 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 / January 2007Copy & condition
Hello to all, I have different ranges of cells in sheet1 as follows: B14:G58 N14:O58 Q14:R58 I need to have a way so as to copy these ranges to sheet3 at the same cell addresses respectively. I.e. to be copy to: B14:G58 N14:O58 Q14:R58 at sheet3 in a way that contents of sheet3 are automatically updated when changes in a cells in sheet1 is changed. i.e. if I typed "Nicolas" in B14 in sheet1 the same value "Nicolas" will appear at sheet3 in the same location at cell B14. Any Help is appreciated. Khalil Go to B14 on Sheet3 and type =Sheet1!B14 Now copy and paste that formula to all of the ranges you have specified. Each of those cells on Sheet3 will be updated in real time whenever the equivalent cell on Sheet1 is changed. - KC > Hello to all, > I have different ranges of cells in sheet1 as follows: [quoted text clipped - 14 lines] > > Khalil Thank you very much it worked well. What I see is that when a cell in sheet1 is empty (no values) the result in sheet3 will be zero. Can I avoide this and have an empty cell with nothing inside? Another thing is that colomn G is representing a year. How can I see the value of 00 if the year is 2000 and the value is entered as 00 instad of 2000. Hope to get help thanks > Go to B14 on Sheet3 and type =Sheet1!B14 > Now copy and paste that formula to all of the ranges you have specified. [quoted text clipped - 20 lines] >> >> Khalil If I may add a couple things. With the links in Sheet 3, the user must not change the cells in Sheet 3. that will destroy the link. It's not a two-way link. To prevent the zeroes, you can use -IF(Sheet1!B14<>"", Sheet1!B14, "") You can use the Fill Handle to copy this into the other cells, both downward and across.  SignatureEarl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- > Thank you very much it worked well. > [quoted text clipped - 33 lines] >>> >>> Khalil Thank a lot it works well. Khalil > If I may add a couple things. With the links in Sheet 3, the user must > not change the cells in Sheet 3. that will destroy the link. It's not a [quoted text clipped - 40 lines] >>>> >>>> Khalil To have dates show the way you want, select that range in column G and go to Format->Cells...on the "Numbers" tab, choose "Date" from the list, and then a bunch of available date formats show up in a new list that you can pick from. Select one that shows the year as 2 digits. > Thank you very much it worked well. > [quoted text clipped - 33 lines] >>> >>> Khalil thanks for the note, but what i ment is I only enter the year in that cell . example: i type 06 or 2006 only and not a whole date; I am using only the year part. Khalil > To have dates show the way you want, select that range in column G and go > to Format->Cells...on the "Numbers" tab, choose "Date" from the list, and [quoted text clipped - 38 lines] >>>> >>>> Khalil Solved! thanks > thanks for the note, but what i ment is I only enter the year in that cell > . [quoted text clipped - 46 lines] >>>>> >>>>> Khalil
|
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.