description

Hi, I have a list of Items names that is coming from another software. The users need to enter enter the description of the item name in a column next to the item name The problem is that the items names changes on a daily basis usually the are more new items but sometimes items that were...

Hi. I have engineers that complete mechanical checks. To standardise the terminology I want them to enter a 2 letter code which in turn displays a description in another cell. The codes and descriptions are on another sheet. I can’t attach the file but here are a couple of pics that are colour...

Hi all, I'm trying to put some code together that looks for a text match in the top row of titles of a sheet... What I want to do is find the column that contains the text "Description" and copy the whole column into a specified column on another sheet. I have some code that looks at the...

I'm updating a workbook someone else created a couple years ago and there are two incidences of worksheets that are identical except that Sheet 1 has the Item, Description and pricing info and Sheet 2 has Item and Description but links back to the first one for pricing info. The main sheet...

I have a PivotTable with just two fields. I'd like to create a calculated field to manipulate that data. IF the DESCRIPTION field is "Contribution" I want to multiply by -1. IF the DESCRIPTION field is "Withdrawl" I want to multiply by -1. IF the DESCRIPTION field is anything else, I want to...

So this might have already been answered. I'm trying to populate the blank rows in column B with the value in the previous row. But when the field is already populated (ie 123), don't do anything. In the next blank cell, use 123 value to populate. below is an example. Thanks in advance...

From a report, the data within one column will have multiple line breaks within the cell which I parsed out via marcro. Here is an example the layout of the mentioned cell: <tbody> Full Text: Here is the full sentence Description: Here is the full description for support. Type (1): Color...

Hello all, I'm trying to get a field within my form to auto-populate, but it's failing, and I don't know why. I need a product description to be pulled from the data, and unfortunately nothing's happening. As a SCSD Employee, when I select a Product SKU, I need the Product Description to auto...

I'm sure that this is already plenty of threads for this, but I'm not sure how to explain what I wish to achieve. Currently I have a list which has a description in. I want this referenced in another table, however I want all the descriptions which match to be grouped together. For example...

I have code that pulls from a database and inputs into an excel sheet (shown below). Selectstring = "SELECT " & c.Item("Ticket1") & _ ", " & c.Item("Description") fromString = "FROM " & ibmLib1 & "." & t.Item("NCType") & " " & t.Item("NCType") & _ "...

<tbody> Code No. Sr. No Customer Description List IF (code) IF (sr. no) sum Textjoin (Description) 1 1 ABC sentence x 1 1 2 1 2 2 EFH sentence x 1 1 2 2 3 sentence x 1 0 1 2 4 3 PQR sentence x 1 1 2 3 5 sentence x 1 0 1 3 6 sentence x 1 0 1 3 7 4 SYZ sentence x 1 1 2...

<tbody> Number Description Measurement (mm) 5897652 Erhöhungsrahmen, MEF33, 320x320x75 2145456 text.... Größe: BxHxT = 900x1250+(800(Sockel) = ignore)x340 mm Text... 2548578 Only text (ignore) 3579513 Text… H:1710mm, B:838,5mm, T:277mm </tbody> Hello everyone, I'm struggling with...

Dear Excel Giants. I have got a problem at hand that needs immidiate attention. and need your help. Our new data base is missin "Description" field from old database. But we cannot directly acess new database we are only allowed to update it using XML file. * So we have extracted excel from...

We are creating price books and the data is currently being updated manually one item at a time. I am hoping to be able to do a data dump with the new costs from our data base and have our price books update automatically. I have 2 sheets with data in 2 of the columns in each sheet <tbody>...

We have been putting together an app for users to fi d great clubs, bars, and restaurants in london (other cities later) As part of the data entry the teams often have written descriptions as a long monologue. I want to break up the text into paragraphs. As it will be read on mobike devices i...

Hello all, I am creating a UDF in VBA for a workbook. The workbook has two sheets: a Budget sheet and aPurchase Order (PO) sheet. Essentially, POs are entered into the PO sheet and the SUMIFS will go thru ALL the PO $ amounts and (hopefully) deduct the respective amounts from the proper account...

Can anyone see the error in my formula? I am trying to extract records for each project description in column G3:G46 from the sheet labeled Tasks. A2 has the project description and b2 has the count...

Hi All, I couldn't find a specific match to this query but I'm assuming it's been asked before - please help or point me to the correct solution :) Thanks. Example: Sheet 1 Cell A1 - Text (basically it a description of a product) Sheet 1 Cell B1 - I will place my formula (this will then be...

Hi Everyone, I have a =IF formula that works great thanks to people here, the problem I would like to solve is a description issue, the example is 6x6 or 4x6 etc. Here is my formula =IF(M12=4,N12*1.5709*4.25,IF(M12=5,N12*2.4545*4.25,IF(M12=6,N12*3.5345*4.25,""))) I need as an example...

Hi! I have tried multiple searches and multiple formulas but can't seem to get this one right. I am close, but I don't get the results I am looking for. Basicly, I want to create two separate sheets. The first sheet will consist of 4x4 squares containing information about ID, Price, Rent...