description

I am going to try to be as descriptive as possible and I am not even sure if this is possible... Thanks in advance for your patience. I have a tab for sheet metal and plate that is part of material charge out for our shop. The person entering the information can choose from various item...

I have a formula that if 95915 or 95925 or 95950 in in Col G, then lookup the description in Col 2 on sheet1 otherwise return the result of the Index formula where 95915, 95925, 95950 is in Col G, the description from the Vlookup is not being used. I only get the results from the Inde formula...

Hello, I'm new at this and trying my hardest to create a pivot table that reads multiple worksheets in my file - but I keep hitting brick walls! I'm wondering if anyone is able to help me, pretty please? My file is for someone who has customers ordering beauty products from her. Each...

I use a lot of data entry on my spreadsheet. Is there a way to create a message box that will tell me the entries that I made during the day? I have 3 different cells that would need to be displayed. the first cell ( cell A) is just a description the second cell ( Cell B) is an amount that I...

Hi all, Apologies if this has been answered somewhere else but if it is, I can't find it. I'm setting up a budget spreadsheet where I download all of my transactions from my bank and run a little macro that automatically categorizes all of my transactions based on an existing table. So for...

Please help me out ... here I am attaching snapshots of two excel sheets 1. has description 2. names of persons What I wanna do is that , I want to check the names of person are matching should indicate me in red or whatever color in different cell from description list. If name is already in...

Am not sure if possible but I want to link to a page that has a series of options for descriptions and to display appropriate text. Ideally I would like a grouped text box of 8 headings with option buttons and if i clicked on anyone of them it would present the appropriate description. I'm...

Hi, struggling a bit if someone can help me out please. I want to create an array with two strings "partno" , "description" I can create a 1 string array but i haven't got a clue :confused:. with two strings Can you please put comments in the code - still finding my way about with VBA my...

Hi all I want to enter data into a "data" tab, with columns "date, name, description, amount" in A-D, but then have a summary tab that I will select a month and all the lines will copy to the summary tab and be sorted by description and date, with a total for each description. I have an example...

This is my first post. I didn't find another post that looked like mine so I apologize if this is a duplicate post. I am creating a spreadsheet that shows 4 years worth of pavement maintenance activities. This spreadsheet is tied to another sheet with all of the budget info associated with...

Hi, I have a column where in each cell there is a summary. I want to be able to delete all the text and number's to the left, including the colon, in the cell with the following text. Full description of Incident: The text before can vary in length. Formula, or VBA, as the column is...

<colgroup><col><col></colgroup><tbody> Account Description PUBLIC =*TAN* and *LOAN* </tbody> Sir Can you pls help me Refer above I use Advanced Filter to extract data but not getting any results I need to specify 1 condition for Account and 2 conditions for Description I guess I am not...

I am wondering if there is a VBA method or guide to have text descriptions automatically fill-in for a Unique ID anytime a user enters a previously made entry in a database. For example, a user initally enters: <tbody> ID Description 1 Description2 X_01 Tall Old </tbody> Ideally, I would...

Hello everyone , I would like to ask if it is possible in excel to have a list ( description , code etc ) and in an other list a description similar to the first list description but written differently , compare them and try to find which item from the second list matches which on the first...

Hi There, please can someone put me out of my misery as I am scratching my head on this. I was sent a worksheet that was basically pasted values from a pivot table, the problem I have is that the header and subheading are duplicating the qty values and i need to display them differently or...

Hello, I'm trying to figure out in Macros how to add the multiple cells under description (M:M) into one cell, so its one continuous descriptions . The one cell with the full description needs to be on the same row with "item" under (A:A). So basically row 3 would have the the information on...

I am curious to know if there is a way to generate a label sheet from an excel spreadsheet automatically? with out mail merge. <tbody> Part Number Part Description Where Qty Have 12345-678-9101 Flux Capacitor 7779 10 ______ 77793-118-6543 DoHickey 4312 50 ______...

Access 2013 I need to parse the field called Description to only contain 7 characters after the (. Can you help?

Hello, I have an inventory list of items, that combines both chinese and english descriptions into it. Is there anyway I can separate them using formulas? The ??? are the chinese characters which may appear before or after then english description. Thank you Sheet1 <colgroup><col...

I have 2 columns of data, one with a product description and the other with Keywords that apply to that product. Currently, the Keyword contains words that are also found in the Product Description. I need to create a new Keyword column that excludes those words. I don't want any whole...