Showing Specific Data from Master Sheet to Another Sheet

I am making a bill of materials at work and have a master list I want to 
access from other sheets.  

The master list has all parts named and categorized, and I want to be able 
to access sections (Hydraulics, Chassis, Electrical, etc.) of the master from 
other sheets.

I have tried pivottables but I am having issues showing the data in it 
original form:

Part Name   Quantity   Material    Expense Category   etc.  
(accross the row)

I wish to be able to make calculations only off the selected data on each 
sheet but I am having immense problems getting there.  

If you can help.
Parker Jones

7/9/2009 7:02:01 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 46

Try this sample from my archives, a non-array formulas solution:
AutoCopy Lines to Resp Sht Non Array.xls 
(Full details inside, nicely rendered. Easy to adapt ..) 

Data is continuously entered in a master ("parent") sheet, with lines neatly 
auto-copied to each individual ("child") sheet based on the values within a 
key column. 

In your case, that key column will be where you have the categories:
Hydraulics, Chassis, Electrical, etc

Celebrate success, click the YES button below
Downloads:27,000 Files:200 Subscribers:70
"Parker Jones" wrote:
> I am making a bill of materials at work and have a master list I want to 
> access from other sheets.  
> The master list has all parts named and categorized, and I want to be able 
> to access sections (Hydraulics, Chassis, Electrical, etc.) of the master from 
> other sheets.
> I have tried pivottables but I am having issues showing the data in it 
> original form:
> Part Name   Quantity   Material    Expense Category   etc.  
> (accross the row)
> I wish to be able to make calculations only off the selected data on each 
> sheet but I am having immense problems getting there.  
> If you can help.
> Parker Jones
demechanik (4694)
7/10/2009 1:01:01 AM

Similar Artilces:

Remote another objects in a another applications
Dear All... Is it possible to control or to remote another objects in another msaccess application from the current msacces applications, that opens in the same time. I had a form to edit some records, and I want to display the results in the other form in the other applications and in the same time I could also control/remote that application like open or close forms or other objects. Currently I'm using dual monitors that attached to one computer but located in different rooms. Is it make any sense?... I've already knew how to remote one object from another in one same ap...

How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in Collumn C. Right now Both are defined by rows 4 to 114. I would like to be able to have the chart automatically redefine itself so if I put a value in C115 the chart would automaticaly set Y value range to be C4:C115 eithout having to manually define chart. Is this possible? If so how? I've tried OFFSET bu so far no luck. Hi, If you turn your data cells into a List, or Table in xl2007, the chart will auto expand. The named range approach will work if you set up the names correctly. See here for more info...

Sheet Tabs #3
Hi All, I am using office 2003. A user that I am support has office 2000 installed and has an issue with displaying the sheet tabs at the bottom of the screen. I have tried a number of options from using the format>sheet>Un Hide. This does not resolve the issue. I have also tried to display the sheet tabs from tools>options>view> and select the option sheet tabs from the window options. None of the above makes the sheet tabs viable. Any ideas on how to resolve this are kindly welcomed. Aaron Aaron, you mean that you can see the tabs but your colleague cannot? Perculi...

Pivot Table not pulling all fields or data
Hi All........ Without getting too verbose, I have a 900 row by 26 column database I am applying a Pivot Table to. The code seems to run fine, but it is not returning some of the fields, and of course the related data. I have tried reformatting the entire columns I am pulling from but no joy......however, when I reformat an errant cell from General to TEXT, that row comes in........and/or, if I change the value in one of the missing cells, it will bring that row in. The code runs fine, and was mostly derived by recording a macro in XL2k, but the data cannot be trusted becau...

Exchange data backup
I'm worried emails backup of the small office. Does SBS2008 Exchange server has a direct backup capability of whole mail database? How to backup every night Emails from server to external harddisk? Does Exchange server needs to be stopped before backup? Thanks SBS2008 Takes care of it. look at the comments section Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Question or Seco...

Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save records, where as the system administrator is able to save the same information. Please advice on this error, what has to be done. I have disabled the windows user ID of the Database owner. Thinking of this made Dynasa as the DBO. Database is having enough free space available. Hi How big is the company database? Is it over 10GB? Regards James "Matthews" <> wrote in message > GP Ver 6.0. Recently I...

How can I print page 2 of each sheet in a workbook?
If I understand your request, the first point to clarify is that "each sheet" does not have a page 2 - If there are 10 sheets & each one contains 2 pages of data, each page is still sequentially numbered 1-20. One option is to select the area to be printed on each sheet and go to File>Print Area>Set Print Area. Once you do this for each sheet, go to the Print dialog box and select Entire Workbook. HTH |:>) "sflower" wrote: > ...

cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) I gave you the INDIRECT option y'day, but received no feedback from you in that thread. Looks like you're more interested in knowing why? One simple hunc...

Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms, modules, and logic) used to CRUD the data in the tables. 1) Is there any way to separate the database from the code into separate files, eg. the db is mydata.mdb and the 'code is in a separate file, eg. code.mdb? 2) Say you have v1.0 of an app and the tables and attributes are populated with data. You then go and build v2.0 of the app, adding tables and columns to what already existed in v1.0, and perhaps moving some of the v1.0 attributes into different tables. What is the recommended way to unload/reloa...

Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels. I want to be able to have them listed under captions like company name, contact, address, city, etc.. so I can use the data. There is an empty row between each entry. Each entry is 3 or 4 rows. There are about 500 records so i dont want to manually set them up. Thanks Try tinkering around with these steps Assuming your list is in col A, data in A2 down (If data starts in A1 down, insert a new row for the co...

Display comments as data #2
thanks a lot , this worked exactly as required, the comment go converted to data Now just one more thing . is the vice versa possible i.e if i have dat in column A can it be shown as comment in column B. the reason i need this is bcos i am shifting some data with thei comments to MS access(Hence the need to convert omments to data) processing them and again converting them to excel (the need to conver data back to comments -- sonik ----------------------------------------------------------------------- sonika's Profile:

How to 1. Jump to a specific page (in a massive document) based on a search then 2. Copy and paste an string of characters a few lines above it.
BACKGROUND/CONTEXT I am working from a very large word document, approximately 1000 pages long. Each page has one 'article' on it. I am currently doing something manually, which I would love to do using a macro. I am populating a table (which happens to be in an Excel spreadsheet) One column is the Article number 'xxxxx'. One of the other columns is a 'Topic' which is typically three alphanumeric characters (like AA1, AD4, BB4 DO6 etc.) PROBLEM/TASK This is what i have to do Step 1 - Jump to the page with the article number. Achieved by p...

Count invalid data entries
I am using the following macro to identify invalid data entries in cells with data validation applied. Sub CheckOrder() ' Application.CommandBars("Formula Auditing").Visible = True ActiveSheet.CircleInvalid Sheets("Configuration").CircleInvalid Sheets("Parts_TakeOff").CircleInvalid MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) & " Configuration and Parts_TakeOff Sheets") End Sub Is there a way to count the number of invalid data entries (red circles) and write the number to a particular ce...

forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view. All the tables, queries, and macros are there. When I open up the database to add data, all the forms are there and can be used. The data is stored. So, it seems that the forms are still there, but just cannot be seen in design view. The database, when I open it up in design view, says Access 2000 file object even though I am using Access 2003 - could that be the problem? Thanks! You cannot open an entire database in Design View. Try opening it normally, selecting a form, and choosing Design View from the V...

Another question, regard enum { IDD = DIALOGID };
Hope it's okay if I ask another question, I noticed that my dialog lacked an IDD-enum. When you create a new dialog project, say, you get something like the following in the public section of the dialog class header: enum { IDD = IDD_ASIMPLETEST_DIALOG }; I noticed I didn't have one in this old project so I added one but it won't compile because the compiler doesn't see the identifier I'm using, which is due to the fact that Resource.h isn't included in the dialog class header file. But the thing is, it isn't included in my test project either but it compiles...

Set Print Preview to always show color
It was easy enough to get Publisher 2003 to perform a print preview in black and white using Tools, Commercial Printing Tools. I want to set it back to print preview in color but it refuses to do so. I have jacked around with all of the radio buttons for Any Color, Single color, Process Colors, etc. but nothing seems to work. If anyone can help me out, please do so. -- Thanks Wes Newman How about the printer settings? Are they set to color? The Generic Color Postscript for Commercial Printing has a color choice in the preferences. Paper/Quality tab. Have you checked the printer pre...

I have two users on the network that are experiencing the same issue. They get new mail and the numbeer in () shows up by the outlook inbox indicating new mail but you can only see the new mail from OWA. I have setup the profiles on differant computers and the problem follows the profile. I have the same similar problem, only I do not get the number. >-----Original Message----- >I have two users on the network that are experiencing the >same issue. They get new mail and the numbeer in () >shows up by the outlook inbox indicating new mail but you >can only see th...

Retrieve information from another field / entity
Hello. I've searched around and found some code for me to be able to get the value from two fields in the Account Entity to two fields in the Opportunity Entity. This would happened on the OnChange event of my "client" / "account" field. This field is the customerid field and is type "customer". It seems the code is doing what it's supposed to do until the end...where it's supposed to populate the two fields in the opportunity. I get the following error: "There was an error with this field's customzied event. Field: customerid ...

Issues Locking A Sheet
I am trying to lock a sheet so that when the form is emailed the person is not able to make any changes. I am selecting the cells I want locked, protecting the sheet, setting a password, but when I email the sheet the person is still able to make changes. What am I doing incorrectly? Nevermind, I figured out my issue. Thanks this site is always so helpful in all my other issues I have come across! >-----Original Message----- >I am trying to lock a sheet so that when the form is >emailed the person is not able to make any changes. I am >selecting the cells I want loc...

Data validation doesn't work if contents is added by pasting
Hi I've data validation set so that only the number 1 can be entered, but even this cannot be entered if an adjacent cell is a certain value. this works for direct entry, but not if the value is pasted in or added using the "drag handle". Is there any way to stop this happening as I just know somewones going to try and fill all the cells by draging the values down. Regards Jeff Jeff, You could disable "Allow cell drag and drop" in Tools | Options or... copy the following code, right click the sheet tab and choose 'view code'. Paste the code into the modu...

Update one text box based on another text box
I'm using Access 2007. I have three date fields we use for follow up: FU1 FU2 FU3 Then I have a text box I've named Status and a check box I've named Not Interested. The idea is for us to enter a date in FU1 after the first follow up is completed. Once the date is entered in FU1, the Status text box is updated to read "First Follow Up". Same goes for FU2 and FU3. If the Not Interested check box is checked off, the Status is updated to "Not Interested". This all works. My problem is if any of the dates are removed from any of the follow up date...

How to get Preview Pane in separate Data File in Outlook 2002
For back-up and portability purposes, we use separate Outlook Data Files. (File, New, Outlook Data File, ....) Then we use the Organizer Wizard to move files from the Inbox to the appropriate data file. All of this works great. The only thing we can't figure out is how to turn on the preview pane on one of these files. It works fine on the standard InBox or any Personal Folder that is in the main *.PST file. We use the described method (View, Current View, Other Settings, check by Preview Pane) and we don't get any error message. However, we also do NOT get ...

Protecting 50 Sheets in 1 Workbook
Hello everyone, I am pretty sure this issue has been kicked around, but is there a way to quickly password protect 50 sheets within one workbook? I have two columns that have formulas and what those protected. ... AKAIK, you need to do this with code. Here are a few solutions. If you're not familiar with using VBA, then David McRitchie has a good introduction on this subject. HTH Paul -----------------------...

Show open work orders on large screen in shop
I have a customer request that may sound sort of unusual. I am having trouble coming up with words for it so that I can even do a search for a solution! It's not that complex, but I don't know the "right words" to search for a solution. I am working on an Access 2KDB for a manufacturing company. One division does onsite repair. They have multiple crews that are dispatched to various sites to perform the repairs. Currently they use a whiteboard to update status of the jobs. The Access DB has a "Jobs in Work" screen that displays all of the key information that the w...

comparing data #2
I was wondering is there a way to compare data from 2 columns in a side by side comparison. I have a large list of numbers and what I want to do is copy another list of numbers into the spreadsheet. But I want the numbers in cell A1 and B1 to be equal if they are is not a match then leave cell b1 empty. I want that to continue all the way through the entire worksheet. Maurice, Do you want to end up with 2 separate columns, or are you wanting to merge the 2 lists into 1 list, without duplications? Dave I want 2 side by side columns. With the numbers that are equal right next to each othe...