description

Hi everyone! I’m trying to put together an expense tracker in Excel. The intention is to take an extract from online banking on a monthly basis which would give me a list of all my expenses. The extract includes the date the expense was incurred, a description of the expense, the amount...

Hi, I'm having difficulty getting a numbering scheme working correctly. I have a list of descriptions that I want to assign a number. If a certain description is used one time the number that gets assigned needs to be the same number that is used if that description shows up again later down the...

i want to be able to stop a user adding more then 100 words into a cell. i have a cell B16 in which the user puts in a description and i want to limit it to 100 words

Trying to improve my pack list. Our worksheet has a unique product number at the top of each column. The cells of each column contain description, weight, size, price, etc. I want to copy the contents of the column (approx 8- 10 rows each) onto a packing list. Currently I find the column...

Hi, please help. My original table is: Row <tbody> 1 Title 1 2 Description1 3 Title 2 4 Description 2 5 Title 3 6 Description 3 </tbody> I need the following result: <tbody> A B C Title1 Title 2 Title 3 Description 1 Description 2 Description3 </tbody> I appreciate your...

Hello Wanted the List of Individuals Name with their Range Address uploaded in combobox So when the form is initialized all the individual's name with range address is displayed in the combobox When clicking on each name in combobox i get the respective information in respective textboxes. in...

Hello all, So I'm trying to do something a little bit complex but am not sure how to tackle it as I'm very new to VBA coding syntax (but intermediately experienced in other programming languages) Basically, I am trying to parse through this text: <Start> <Step> <Description>...

I am trying to figure out how I can have a drop down list to select from and have a description of the code I am selecting. For example: <tbody> Code Description 1100 Project Management 1200 Project Coordination 1300 Administration </tbody> Drop down only shows the code but no...

Hi All, I'm trying to develop a Userform to capture defects detected in an electronic manufacturing plant. Userform (below): I have managed to set up dependent combo boxes that helps to identify the customer and part number. I would like the Assembly Description to be populated in a...

I am not sure what Im missing in this code but Im stumped. I need to take column values from one sheet and place them in different columns in another sheet. I have both files open and the sheet names are set as "Sheet1" but I keep getting a SubScript out of Range error. Any help or suggestions...

I am trying to create a price list and the vendors part numbers and descriptions are different that our database. I would really prefer not to go through thousands of items one by one and change them. Is there a way to use a partial reference system? =Index(Match) =if(VLOOKUP) <tbody> My #...

I have a table with a column named "Description" and another column "Tags". I have a named range "tag_data" that lists all the tags I want to search for in the description, and then concatenate the tags into the Tag Column: I am using a function I named ConcatenateArrary based on a...

Hello, this forum has been great. You all helped me with many functions including the VLOOKUP. However, I'm stump on one issue and I need some assistance as to what i'm doing wrong. I was able to get the VLOOKUP function to work perfectly. Now I want to add another VLOOKUP with the column index...

Hi, I am learning how to use htm within .htmlbody. I pull a bunch of dynamic values and am wanting to make these bold. " PO Description: " & ""&Range("H" & (ActiveCell.Row)).Value&"&" & " " _ The "" works but the "" gives me an error. For some reason it refuses to accept my html coding. In...

Hi there, We have a system that issues tabled data which appears in the following format:- Column A | Column B Level | Description Top Level | Top Level Description (2 "spaces") 2nd Level Code |(2 "spaces")...

Hi All A while ago I used a forum and posted a problem which was solved by using a VBA script. This script works most of the time but not always. The original problem I had was that I get given an excel sheet with 3 columns detailing a description, a part number and a location. I needed...

Hello, I have a Work Order Table that has Part Number and Description. I also have a Part Number Table that has the part number and description of that part number. How can the Work Order Table autofill the description field when entering in the part number field? Thanks, XJ

Hi Everyone, I am very new to Access and need some help with some queries. I have one Table that contains a Date, PLUNumber, Description, PriceEach, ItemsSold, and TotalSales fields. I have a date range query already set up but I am looking for a way to enter a scan or type a description in a...

Hi, Please could someone help me some match the data in columns 'Transaction Number' and ;Line Description': <colgroup><col><col><col></colgroup><tbody> Transaction Number Transaction Line Description Date Rejection for Invoice 5-Nov-18 Miscellaneous_Negative_Entry_For_NEW...

Hi All, I have problem that I think I am overcomplicating and was hoping I could get some advice please. In my spreadsheet there are two pertinent columns. One is a dollar amount and the other is a description. ex. <tbody> COIN 0.71 CASH 5.00 CREDITCARD4786 18.99 CASH 4.00...