 |
 | 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 2007Chart on a different sheet
I have numbers on SHEET2 that are all 7 cells apart: A1 A8 A15 A22 etc I want to create a chart on sheet 6 so I have copied the coordinate as such yo shhet 6 =Sheet2!:a1 =sheet2!a8 etc etc Is there a way that this could be done jmucg faster and better as my list is becoming very long. Thanks In Sheet6, Place this in any starting cell, say, in B2: =INDEX(Sheet2!A:A,ROWS($1:1)*7-6) Copy B2 down as far as required. B2 returns the same as: =Sheet2!A1 B3 returns the same as: =Sheet2!A8 and so on  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > I have numbers on SHEET2 that are all 7 cells apart: > A1 [quoted text clipped - 10 lines] > becoming very long. > Thanks Thanks for the help. I would apperciate it if you would explain the folllowing: I assume ($1:1) refers to A1 what does the " *7-6" do thanks > In Sheet6, > [quoted text clipped - 19 lines] > > becoming very long. > > Thanks 1:1 refers to the first row and returns 1, *7-6 means multiply 1 (what rows return) by 7 then subtract 6 that part will return 1,8,15 and so on SignatureRegards, Peo Sjoblom > Thanks for the help. I would apperciate it if you would explain the > folllowing: [quoted text clipped - 27 lines] >> > becoming very long. >> > Thanks Your help is much appreciated > 1:1 refers to the first row and returns 1, *7-6 means multiply 1 (what rows > return) by 7 then subtract 6 [quoted text clipped - 31 lines] > >> > becoming very long. > >> > Thanks What code would I require if I wanted to start at Col D row 200 and work down Thanks > 1:1 refers to the first row and returns 1, *7-6 means multiply 1 (what rows > return) by 7 then subtract 6 [quoted text clipped - 31 lines] > >> > becoming very long. > >> > Thanks It should be the same, that's the beauty of using rows as opposed to row. Of course if you meant that you want to get the first value from Sheet2!D200 then just change it to =INDEX(Sheet2!$D$200:$D$65535,ROWS($1:1)*7-6) and copy down but if you mean that you want to put this formula in D200 then it would be unchanged SignatureRegards, Peo Sjoblom > What code would I require if I wanted to start at Col D row 200 and work > down [quoted text clipped - 37 lines] >> >> > becoming very long. >> >> > Thanks That was just great.Thanks- I was looking for the "FIRST" > It should be the same, that's the beauty of using rows as opposed to row. > [quoted text clipped - 49 lines] > >> >> > becoming very long. > >> >> > Thanks
|
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.