lists w/ multiple worksheets q

I am trying to create what I think is a strange spreadsheet and at this
point I do not even know if it is possible.  I have 3 worksheets that I
have named database, GUI, & totals.  The database sheet contains a a
number of rows about a item the user can select.  The first column is
the name and the next 10 or so columns are specific information about
that item.  The GUI worksheet has a new row for each day.  Then I
created a list of all the items in the database worksheet.  The user
can then on the GUI worksheet select a number of different items from
the list (each item is a different column for a specific date).  Now
this is where I get lost.  My third worksheet I want to total up some
of the properties from each item the user selected for the day.  For
example, for 9/28/05 the user selects ITEM1, ITEM3, & ITEM5 from the
lists.  So now I want in the total sheet the price of all three items. 
I know what item in the list was selected but how do I get the price of
that item off the database worksheet?  Is this possible?   :confused:


-- 
theqcup
------------------------------------------------------------------------
theqcup's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27636
View this thread: http://www.excelforum.com/showthread.php?threadid=471551

0
9/28/2005 8:32:16 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
486 Views

Similar Articles

[PageSpeed] 14

Try looking at some of these links:
    if you have many sheets with the same exact format
    http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

    VLOOKUP   you might need this for pricing
    if you are trying ot lookup a value from a table
    http://www.mvps.org/dmcritchie/excel/vlookup.htm

If you have to manually select (skipping some items) for a total
that is not very good,  can you perhaps use   SUMIF Worksheet Function
    http://www.mvps.org/dmcritchie/excel/sumif.htm

I think you will want a macro to cycle through your selected items
and add them to a column in your GUI worksheet with a date or
other id at the top.   Before you write a macro,   you must have a
clear idea of what you are doing manually.

Updating a worksheet while going through a selection of cell on
a different worksheet.   Some code snippets might be extracted from
     http://www.mvps.org/dmcritchie/excel/sheets.htm
      http://www.mvps.org/dmcritchie/excel/join.htm
      http://www.mvps.org/dmcritchie/excel/bus_sched.htm


If you are going to post to the Excel newsgroups, it would be much
more friendly to use your name, so we know who your are and what
to call you.  It probably also means a little more care to posting
questions and answers will result.
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

"theqcup" <theqcup.1w37md_1127941509.6545@excelforum-nospam.com> wrote in message
news:theqcup.1w37md_1127941509.6545@excelforum-nospam.com...
>
> I am trying to create what I think is a strange spreadsheet and at this
> point I do not even know if it is possible.  I have 3 worksheets that I
> have named database, GUI, & totals.  The database sheet contains a a
> number of rows about a item the user can select.  The first column is
> the name and the next 10 or so columns are specific information about
> that item.  The GUI worksheet has a new row for each day.  Then I
> created a list of all the items in the database worksheet.  The user
> can then on the GUI worksheet select a number of different items from
> the list (each item is a different column for a specific date).  Now
> this is where I get lost.  My third worksheet I want to total up some
> of the properties from each item the user selected for the day.  For
> example, for 9/28/05 the user selects ITEM1, ITEM3, & ITEM5 from the
> lists.  So now I want in the total sheet the price of all three items.
> I know what item in the list was selected but how do I get the price of
> that item off the database worksheet?  Is this possible?   :confused:
>
>
> -- 
> theqcup
> ------------------------------------------------------------------------
> theqcup's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27636
> View this thread: http://www.excelforum.com/showthread.php?threadid=471551
>


0
9/28/2005 10:29:02 PM
Reply:

Similar Artilces:

Customizing Activities\History LIst
Is there a way to add a date to Activities' History list? It would be nice to know when each activity happened. Thanks, Troy Troy, no way currently, although Microsoft has mentioned it might be an option in version 2.0 (nothing is guaranteed!) A few ISVs have custom products that do it... www.salentica.com www.c360.com Dave "Troy" <anonymous@discussions.microsoft.com> wrote in message news:af6b01c436bd$ce671f00$a001280a@phx.gbl... > Is there a way to add a date to Activities' History > list? It would be nice to know when each activity > happened. >...

Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will be numbered in "level 1" and have indented bullets in "level 2." For such a list is it better to define a multi-level list style and linked paragraph styles? Or use one's already defined numbered list and use one of the Word's pre-defined bullet lists when needed for the second level? As part of this question, is is preferable not to have a style "nested" within another style or doesn't it matter? Thank you. -- Norm Hi Norm: I'm not sure why yo...

Distribution List Changes
Hi All, I have a mail enabled distribution list with four users. Only those users plus the Administrator have rights on this group. Yet a seperate user is able to add / edit or remove users to this group even though they do not belong to this group. The user does not even have admin rights and is able to make changes. Let me know of any options I can try. Thanks Waynear wrote: > Hi All, > > I have a mail enabled distribution list with four users. Only those > users plus the Administrator have rights on this group. > > Yet a seperate user is able to add / edit or remov...

Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some do not. All sound came from the same folder. Also, when playing the slides while in PPPresentation, swome have sound and some do not despite all being indicated on custom annimation lisy and all startin "after previous." Thanks! Often when one sound plays but another doesn't, it's an issue of the length of the file path. What's the file path to your music? Is it really long? If so, the longer-named songs might just be hitting the length limit. -- Echo [MS PPT MVP] http://www.ec...

Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I have a drop down list like this [image: http://www.geocities.com/augurtrade/excel_checkbox.txt] and this [image: http://www.geocities.com/augurtrade/excel_checkbox2.txt] ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible for me to see only all the check box that was checked or vice versa...??? How to make a total below the checkbox i mean when someone check the check box, a total number appear below the last check box [image: http://www.geocities.com/augurtrade/excel_checkbox3.txt] [image: http://www.g...

how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted me is still on this list (I don't think she blocked me), but when I check who deleted me on blockstatus.com, he shows up. could it be it's not updated? which of the two would be more reliable? -- maykk Greetings, Do not use these websites, they will steal your identity and sell it. You should change your password immediately. That said, in general, the "who has..." list within Messenger is accurate. There have been instances over the last six-months or so where the list (and m...

=?ISO-8859-1?Q?Import_in_Excel,_Datums-_und_W=E4hrungsproblem...?=
Hi Alle Folgendes Problem: Ich bekomme aus einer Datenbank regelm��ig ein CSV, das ich mit Excel bearbeiten m�chte m�chte. Problem bereiten mir zwei Felder: Ein Preisfeld, das als W�hrungszeichen einen Punkt hat und ein Datumsfeld, das das Format JJJJ-MM-TT hh:mm:ss hat. Excel formatiert beide Felder um und zwar setzt er bei dem Import anstelle des Punktes ein Komma und �berschreibt die Datumsformatierung zu TT.MM.JJJJ (die Zeiten fliegen ganz raus). Wenn ich die Datei nach der Bearbeitung exportiere, dann sind nat�rlich die urspr�nglichen Formatierungen im Eimer und die Datenbank freut sich...

Rules not Running Q
I am running Outlook 2003 Terminal Services and each morning I come in the Rules that I have set up have not run. All my mails go into the general inbox but you can't actually see them although you can see the number unread. I have to close the application, open again, then they appear in the Inbox (still i the wrong folder). I then run the rules manually and everything works fine, including auto run of the rules until the end of the day (or when I come in the following morning) when itall starts again. What is causing this problem? I do have all available updates from Microsoft installed...

How can I set up a shared excel worksheet and work offline
I have a group of laptops on a windows 2003 network. I have set up shared Excel Workbooks to allow users to modify different worksheets at the same time. I would now like to take this a step further. I want to allow two or more uses to take a copy of the shared workbook away from the offce with each user being able to work on their part and then be able to save them back to the network with all changes being saved. I was hoping the "make available offline" feacher would work but it seems that it will not. Please give any suggestions of workarounds or other software that ma...

Calculating over multiple tabs
I need to end up with a total of a person's expenses across multiple tabs. I do have a unique identifier. However, each person can only receive $400 from each tab (category). But they may not be in all tabs. Thanks! ...

Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those with a common extension i.e. all those who have email addresses @hotmail. I am using Outlook 2007 Can you do a search or advanced search which will show the contact you want to delete? You should be able to highlight & delete them from the results. "GrahamC" <GrahamC@discussions.microsoft.com> wrote in message news:6AC1880D-9632-4ED9-BAE2-7083690B9FA7@microsoft.com... > I have all my contacts in the Contacts List and I want to delete all those > with a common extension i.e. all t...

Combining multiple documents in Word 2007 (track changes) 03-22-10
I submitted this question in early March with the exact same subject (I am no longer able to find it on the site). Can anyone tell me how I can view multiple documents at the same time so I can review the tracked changes and accept them into the original document? Word gives the options to: "Compare - Compare two versions of a document" and "Combine - Combine revisions from multiple authors into a single document" but I an only view two documents at once.....the original document and one that has had changes made. If I have sent the original to 12 in...

Print multiple labels for each order line
I am trying to design a label report in Crystal which runs off a sales order. The label report prints the item number. I need the report to print as many labels as the quantity on the sales line so if there are 2 lines on the sales order for quantity 10 and 15, then I want 10 copies of labels for the first item and 15 for the next. How can I build this into my crystal report. I was unable to get the same process of printing labels in an efficient manner; so I came up with another idea of getting it done. Let me know if you are interested to explore my idea. "Jack" wrote: &g...

Script to list access right
Hi I am trying to find any script which would generate list of login users with certain access level (select, write etc.) at one particular database. Is there something like that? Thanks. Justin ...

Smart List export to Excel #2
Hi, We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List export to Excel, we keep getting an "Exception_Class_Object_Exception" that references varying object errors, such as 'Cells' or 'Value'; the object errors will change each time we try an export. As a workaround, I've found that closing Excel before doing the export allows the export to complete successfully. However, that solution isn't acceptable, as our Dynamics users would like to be able to work in Excel, doing other tasks, while the export is processing. Does anyone...

a list of lists
currently i use CArray to keep track of a list of objects, but I don't know MFC classes well enough to keep track of a list of lists. I'd appreciate some suggestions "wanwan" <ericwan78@yahoo.com> ha scritto nel messaggio news:1187535523.924671.143350@j4g2000prf.googlegroups.com... > currently i use CArray to keep track of a list of objects, but I don't > know MFC classes well enough to keep track of a list of lists. I'd > appreciate some suggestions You might want to embedd your list based on CArray into a class (e.g. CListOfSomething), and then ...

Advanced Find Multiple searches
In CRM 1.2 Advanced Find I was able to type in multiple account numbers separated by a semi-colon adn it would pull up the multiple accounts. I noticed that CRM 3.0 will not allow multiple entries. Is there a way to change that to allow multiple entries? I am aware of the groups, and that takes too much time, even if you have saved views. Any suggestions? You can use advanced find for this. If you do this frequently you may want to set up a 'saved find' with a number of rows which basically all say 'Account Number' EQUALS and then enter the values you are looking for. ...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway to have exchange add the GAL to the outlook contacts on the workstation, so that when they sync up, they will retrieve the Global Address List? In news:%23TkYtT0$GHA.3560@TK2MSFTNGP04.phx.gbl, Flip <phil.atkinson@beltek.com> typed: > We use Ipaqs throughout the company, and I was wondering if there is > anyway to have exchange add the GAL to the outlook contacts on the > workstation, so that when they sync up, they will retrieve the Global > Address List? No (and this wouldn't really be an ...

Formatting a pivot worksheet to display a string at the end!
Hi there, I have created several worksheets using the 'Show Pages' function, but now need to add a bit of blurb underneath each of the pivot tables. I was thinking of doing this in the Page Footer, but this will be displayed on every page - and some worksheets will span several pages. Can anyone tell me if there is an easy and quick way of adding some text to the end of the pivot tables in every worksheet (there are 50 worksheets!) thanks in advance, Matt -- matpj ------------------------------------------------------------------------ matpj's Profile: http://www.excelforum...

how to link to external worksheet
I am using excel 2003 and am trying to link a worksheet from one spreadsheet (source) into a second spreadsheet (destination). The source spreadsheet may or may not be open when accessing the link from the destination spreadsheet. I figured out to go to the source, select the whole sheet, ^c, then switch to a blank worksheet in the destination and Edit->Paste->Paste Special. From there I "Paste link", then paste "format" and "column widths". My first problem is that any blank cells on the source worksheet come over as 0's on the destination, ev...

Fields in items list-- add/delete
Hai, I am using RMS version 1.2. In Stores Operations Manager it displays list of items when click on Database-->Items. It displays only five columns. Now i need to add / delete some fields in this list. Is it possible to add or delete the fields? if yes how can i add the fields? Thanks in advance, Nagendra On Wed, 27 Apr 2005 01:22:02 -0700, "Nagendra" <Nagendra@discussions.microsoft.com> wrote: >Is it possible to add or delete the fields? if yes how can i add the fields? I don't think so antonio ...

use w/ hand held devices
Can someone tell me which handhled device or software I need to be able to retrieve my outlook e-mail. See if the information on the following page helps: http://www.slipstick.com/addins/olpda.htm -- Jocelyn Fiorello MVP - Outlook *** Replies sent to my e-mail address will probably not be answered -- please reply only to the newsgroup to preserve the message thread. *** "PS" <Philly58@aol.com> wrote in message news:025201c35850$eac20e40$a101280a@phx.gbl... > Can someone tell me which handhled device or software I > need to be able to retrieve my outlook e-mail. ...

remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has about 6,000. I need to remove the 6,000 from the 16,000 as they all appear in the big list as well. How do I extract those 6,000 entries from the larger list? My expected result is a mailing list with 10,000 names. Chip Pearson has some techniques at: http://www.cpearson.com/excel/duplicat.htm Howie J. wrote: > > I have two mail lists on excel. The first has 16,000 names, the second has > about 6,000. I need to remove the 6,000 from the 16,000 as they all appear > in the big list as well. How do ...

To-do list
In Outlook 2007, I can't find a way to show a short summary of my e-mail inbox on my Calendar page, similar to the way Outlook shows a To-do list of calendar items on my Mail page. It would save me a lot of switching back and forth. If there is a way, please tell me. If not, maybe you could consider adding it to the next version of Outlook. Otherwise, I love the program. -- BB ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the mes...