Computer Hope
Software => Computer software => Topic started by: redbrick on October 26, 2010, 08:02:11 AM
-
I have a summary price list but want to drag info from a secondary work sheet (this sheet carries the calculations) for the summary prices. Prices must appear in the same row as the descriptions. Could this be something like a VLOOKUP function? ???
-
Need more detail in what you want to do.
Are both pages in the same book?
Normally, the source and target areas would have the name structure. Are toy trying to juxtaposition rows and columns?
Gave you already read this?
Using Drag and Drop in Excel 2007
By Greg Harvey
Read more: http://www.dummies.com/how-to/content/using-drag-and-drop-in-excel-2007.html#ixzz13TWSeD8X
-
juxtaposition
juxtapose
-
Need more detail in what you want to do.
Are both pages in the same book?
Normally, the source and target areas would have the name structure. Are toy trying to juxtaposition rows and columns?
Gave you already read this?
Using Drag and Drop in Excel 2007
By Greg Harvey
Read more: http://www.dummies.com/how-to/content/using-drag-and-drop-in-excel-2007.html#ixzz13TWSeD8X
I am familiar with drag and drop! Yes the pages are in the same book. I need to calculate prices on the 'secondary page' and 'deliver' the total price to the correct description/line to the summary. Hope this helps ???
-
I am familiar with drag and drop! Yes the pages are in the same book. I need to calculate prices on the 'secondary page' and 'deliver' the total price to the correct description/line to the summary. Hope this helps ???
That sounds like simply having a formula on one sheet that refers to another sheet. The "secondary page" would have a formula for the total price and the primary sheet would have a formula referring to the total on the secondary sheet. If this does not relate to what you want to do, then I still do not have a clear picture of what you're trying to do.
-
IIRC Excel allows you to refer to other sheets in formulae via a SheetName! type syntax; for example, if you want to include A6 from Sheet4 in a calc, you would use Sheet4!A6.
I think this is the case, anyway. I haven't really used excel versions other then Version 5.0 very often.
-
IIRC Excel allows you to refer to other sheets in formulae via a SheetName! type syntax; for example, if you want to include A6 from Sheet4 in a calc, you would use Sheet4!A6.
Correct. I was leading to that but was waiting for a reply from the OP first.
-
Has your question been answered? If you want the answer that is listed on the sheet named "calcs" in cell C17 for example (I tend to name my sheets) to be listed on sheet1 cell D36, all you have to do is in D36 use "=calcs!C17". The same can be done if you want to reference a different workbook entirely as "='[filename.xls]sheet!cell".
-
One thing to add. If you link two sheets together, which is easy and common, both files need to be always together on the same HD or medium.
-
One thing to add. If you link two sheets together, which is easy and common, both files need to be always together on the same HD or medium.
Are you sure about that? I just did a test and the results contradict your statement. I saved an Excel file containing a formula on a sheet which summed a few cells. Then, I saved an Excel file on the hard drive with a formula referring to the first file, and I closed that file. Then, I opened the first file (on flash drive) and changed a value in a cell, saved it, and closed it. Then, I opened the second file (on the hard drive); the value displayed in the cell containing the formula linking to the other file did not automatically update but it did update when I selected the Data ribbon (Excel 2007) and told Excel to update values.
Of course, the flash drive was connected all this time. Obviously, it would have to be connected. But, again, one file was on the flash drive and one on the hard drive.
-
Thanks for the replies - I am familiar with formula from sheet to sheet however the data in the 'secondary sheet will have to be updated from time to time (for raw material increases for instance) and there will be new prices to add. I need to be able to up date item for item regardless of the slave/master relationship of position on the page. Any help? ???
-
So, in other words, the position of the cell containing the sum on the secondary sheet will change, right? In that case, you would need to adjust the formula on the primary sheet.
You could leave some empty rows in the secondary sheet, above the formula, to allow for adding of new items without necessitating an adjustment of the formula on the primary sheet each time a new item is added to the secondary sheet.
Another solution would be to convert this whole application to a Microsoft Access database.
-
Are you sure about that?
I probably should have worded that differently, but the two files need to be able to communicate, whether it's between two HDs, flash drives, or what ever.
-
Thanks guys, just what I was looking for