| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 70222 | 2006-06-26 05:23:00 | Excel Sreadsheets | rny (6943) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 466168 | 2006-06-26 05:23:00 | Hi folks, is there a way or function to share data between two or more worksheets in a Excel Spreadsheet? Data would be via a formula, so would need to be able to share the values only. Sorry for my apparent lack of knowledge as I am still getting the hang of using Excel. rny. |
rny (6943) | ||
| 466169 | 2006-06-26 05:37:00 | Yes there is but a few more details would help. | FoxyMX (5) | ||
| 466170 | 2006-06-26 05:52:00 | Ta for the reply, here is what I am attempting to do as best as I can explain. Results from a sporting event involving a number of people from different clubs, need to be sorted into an order of highest to lowest, over a series of matches, and then a formula applied to apportion prizemoney depending on number of entries and entry fees, (already have that), for each of the matches, then sort into various clubs so the final print out contains the infomation for each club. Am achieving the desired result at the moment by doing a lot of copy, paste special between worksheets. Am just looking for an easier and less time consuming way. Hope this helps. rny. |
rny (6943) | ||
| 466171 | 2006-06-26 06:22:00 | We have Excel gurus here that ought to find that a piece of cake so sit tight and hopefully they won't be too far away. :) | FoxyMX (5) | ||
| 466172 | 2006-06-26 06:35:00 | Crickey. Sounds confusing. :waughh: | rob_on_guitar (4196) | ||
| 466173 | 2006-06-26 06:53:00 | Sounds like the easiest thing for you to do would be to put the information from each of those spreadsheets into the one spreadsheet on to different "sheets". Then you can reference the data between each sheet a lot easier and can create formulas between them quite simply. Otherwise you can still access data from different spreadsheets by referencing the name of the spreadsheet like so: ='[spreadsheet_name.xls]Sheet1'!$A$5 or something similar.... EDIT: an easy way to do this is to open up the spreadsheets to be referenced in Excel. Hit = or start typing your formula and then you can switch to the other spreadsheet and click on the desired cell and hit enter and it will insert the reference to that cell automatically. |
bunta (10620) | ||
| 466174 | 2006-06-26 09:15:00 | Thanks bunta, looks like an easy fix, will give it a try. rny |
rny (6943) | ||
| 466175 | 2006-06-26 20:15:00 | Hi, if you are receiving a number of workbooks which need to be collated (eg 10 people giving you a workbook and you need to take the results from each and populate to one workbook) then if the workbooks have the same format it may be easier with code depending upon whether the process gets repeated and how many people involved. For example, you can place the books into a folder then have code loop through every file in the folder and bring in the info. If this is the case then you can email me at parryishere@yahoo.com.au with the destination book and a book that has already had data inserted with the specific data highlighted in the destination one so I can see where you place the info. regards, Graham |
Parry (5696) | ||
| 466176 | 2006-06-27 01:07:00 | Thanks for the reply Graham, with the info supplied so far, I have been able to achieve what I set out to do. Learning more about the capabilities of Excel all the time. Thanks again. rny |
rny (6943) | ||
| 466177 | 2006-06-27 04:24:00 | There are a couple of more possibilities than just link one cell. You could work with named areas and / or use the VLOOKUP formula to get data from one sheet to another one. If you collect workshhets and want to cumulate them, you can have different layouts, if you use Named areas. |
MMNZ (10621) | ||
| 1 | |||||