component

Hi i have basic excel knowledge. I am trying to create a prcing tool for selling laptops (for context) so i want a tool where i cant input all my component prices (differnet ram, hdd etc) then i want to enter my basic unit price, then have drop downs, for each component, it will take the cost...

Hello, I'm trying to create a "Summary" worksheet by pulling data from other worksheets with in the file. The worksheets are all journals and there is a column in each worksheet that lists components from a dropdown. In the summary worksheet I want to create a spreadsheet where you can...

Hello, I am in need of assistance. I'm working on a spreadsheet to simplify my work life and have run into a wall. At a high level, the purpose of this spreadsheet is to determine the items & inventory available for me to send to a third party weekly. I'm going to try my best to put...

Hi Guys, can anyone tell me what's wrong with the following construction, please? All three components work individually so I assume it's the way I have put them together that's the problem. In the below, only the first component works...

Hi Everyone, I am looking for a VBA solution for the problem described below but I couldn't figure it out. Any help would be great! The "Large Number" column and the "Component" column are the input and they are all integers. I was wondering if there is a VBA solution to "break down" the...

Simplifying as much as possible, my data is structured as below. What I'm trying to return is the sum from one of the component cost columns of table 2, of entries that are "X" category and "TRUE" boolean from table 1. In the example below, the sum for "X" category, TRUE should return $4.00...

Hi, May I know how to write a code to automatically filter each component types (C type, P type) available in my data, copy paste to their respective sheet and arrange according to their component names (C-100, C-10, etc)? <tbody> Component Amount C-100 4 C-10 5 P-150 7 C-100 3...

I basically created two excel sheets. One with parts + price and another with a master sheet for components and price, basically on the parts sheet there are about 3000 line items of parts containing two components each. I need a foruma that will grab the price data from the component master...

Hi all, Looking for some help on this. My colleague and I have developed a pricing tool that we use for costing component parts. Often these component parts are very similar in terms of manufacture with the only difference being that the size of the component alters. We've set the spreadsheet...

I am trying to set some code in my macro to send an e-mail of a worksheet but I am getting the following error: (ActiveX component cant create object) Set OutApp = CreateObject("Outlook.Application") How can I adjust my code to create the object? thanks,

receiving a run-time error on some provide vba code not sure why? Active X Component can't create object. Any help would be appreciated. Thanks

Hi, I have multiple Rows (within a Column) that I want to SUM but some have #N/A in them. When I have the formula to create the Total, I want to be able to drag it across 24 Columns. I have found 2 examples - both work in various situations but not my specific one. Can anyone suggest a...

Hi, I have a 12 month table (3 columns per month - Sales Value / Margin / No. of orders) - 36 columns in total. I have 3 columns in Columns A / B & C which are Product / Category and Suite/Component - table examples below. I want to be able to match the Category with Component and the Max...

I have the following code in Excel 2010: Option Explicit Dim active_row As Range Private Sub CommandButton1_Click() Set active_row = Sheets("active").Range("A2:L2") active_row.Interior.Color = RGB(0, 255, 0) End Sub Private Sub CommandButton2_Click() active_row.Interior.Color = RGB(255...

Worksheet A (Base Volume Data) contains a list of project numbers with a quantity per week for each project. Worksheet B contains activity data for component parts in these projects; Column B contains project numbers; Column N contains cycle times for a specific operation. Obviously...

Hi I have a pivot table with just 2 columns. The Data set, about 50k+ rows, is also the source for other tables. Column 1 is a component Part No. while Column 2 is a list of products in which this component is used. Setting up the table was no problem. Both columns are "Row Labels". The...

I'm new to Access (moving over from Excel because the databases were too big) and I was wondering the best way to duplicate how excel manipulates data. I have two tables that need to interact: Table 1 - Gas Component Percentages in a sample (Methane, Ethane, etc.). Each sample processed is a...

Hello everyone! Tab 1 called "Component Matrix" I have a list of all my components vertically in Column C --> C5:C11 I have a list of all my programs in column F4:J4 See below for what I mean - This table represents a usage matrix. Program 2 has 1 of each of the following components - 1...

Hello, I'm trying to take a list of items and components and create a heirarchical Bill of Materials from the data sample shown here. The total list will be for 12000+ rows. <tbody> A B C D E 1 Item Number UOM Component Component UOM Quantity 2 CPT001A EA FPM1010R MS 0.19 3 CPT0002A...

First let me acknowledge that each component of my question has been covered however I think this is unique, and probably simpler as I only want to return the value AND format of one cell, but it is from an closed external file. I'm new to VBA and the answers to each component of my question all...