description

Hi guys I want to enter a PartID(text) in userform TextBox1 and have the userform display an alternative PartID in TextBox2 and description in TextBox3. Sheet1 has PartID1, PartID2, and Description in column A, B, and C respectively. I have this code below which appears to have worked for...

Hi, I have been struggling with this VBA code for quite some time now and would appreciate any help with it. I have attached a sample spreadsheet I am working with. First sheet shows the raw data that comes from the SharePoint and second sheet shows the report I am trying to build form the raw...

I have an issue where my company got into the habit year's ago of denoting discontinued product with an astericks in our product description field. Management do not want this changed. This is an issue for me. Is there a way where I can use the astericks in a formula where only an astericks...

Hello everybody I am seeking so advice on how do collate a summary for the financial year of the invoice date, hours worked, the associated codes (possibly 4 per invoice), and total dollar value. Thanks in advance I generate weekly invoices with the (day In Column A), (the date in column B)...

Goodreads does not have an api for this :( . I need to extract description of books from goodreads.com for my big list of books. Any help please.

Hi, I have a Manufacturer # that I search for on a website and need to pull the; Manufacturer name, part number and Description. The website used to search is https://www.mscdirect.com/ Using the number 63713408 as an example, I have to search for 63713408 in the search bar and then copy...

Hello, I got two set of data that needs to be align by id. I need a formula/vba to go down two sets of number and insert a blank line if there's no match and go on to the next number. One set of data is a-d and the other is f-i. I was only able to find something that only insert blanks into 1...

Hi guys, me again, a VBA beginner. I have the information below:- Column B1:E1 are the description. Then we copy the data from other sources based on these description (FilexxNAME, Nature, Place, Tool). We dunno the total number of the series. It can be 6 series (like example below), or it...

Hi Everyone I am currently trying to use a data base to find out which parts go onto which machines I currently have a list of all the parts that i am using and next to each part i have each machine number that uses that part. <tbody> Description 34562 Brown Link wire 53456 45366...

Hi is there any formula to do the following? I have a table of text which i want to use as classification. And i have a data table with various description. and i wan to match the description with my classification. Classification Table <tbody> Happy Sad Cry </tbody> <tbody>...

I'm exporting a list from SharePoint online that exports lookup columns and their ID which is impossible to change. On Export, this is what it looks like: [![enter image description here][1]][1] Is there a way that I can write an Excel function to delete specific characters combinations? I...

Hi all, I would like to use a VBA code so that to “revise” the numbers in col. “J” if the account in col. “E” is “450102 ADMIN”, “450102 RES”, “605102 ADMIN” and “605102 RES” Therefore, that should make the proper deduction and then should turn the negative number into positive. Below I present...

Hi Good evening, I am always happy to get your magical solutions for challenging questions... I am working in a excel which contains school bag, travel bag & lunch bag inward informations as below.. <tbody> s no date bag description rate qty total value selling price 1 01/12/2018...

<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} Page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} td...

I have a long description in my item master and want to extract the first string after the number 205 in the description. I understand the logic by following other examples but can't get it to work. Here is the long description that is essentially a big text box. I formatted the text to at...

Hello, i am having trouble getting my formula to work properly. =COUNTIFS(table_name_first_table[tablerow_name)];"*";table_name_first_table[tablerow_name)];"name";tablename[tableRow_description];"*new*") So, i want to count how many times name of the person shows up given two criterias. First...

Hi all, kindly advise me so that to create a VBA code which should copying the left 7 characters from Col. “H” to col. “E” and place the account type in col. “D”. Account types are: If start col. “E” from 5 = D...

I have a sheet with values: cat | cat description | cat.jpeg rat | rat description | rat.jpeg dog| dog description| dog.jpeg How do i get it to show like this on the speed sheet: cat cat description cat.jpeg rat rat description rat.jpeg dog dog description dog.jpeg Thank you for your help.

I have a “Master Parts List” sheet where Part Numbers start in A2 and Part Description starting in B2. I have ~ 25 Sheets each with a different name where there are columns in each. I want to match the Part Number & Description to the Master Part List and sum the total Quantity of parts from...

I have 5 columns, I would like to populate a new column on another worksheet with following criteria: Populate column 1 with description when the subtype is raw material. I want to do this by using a formula, <tbody> Gl Account Description Asset Subtype Period Balance 123456 Bank Account...