description

Hi to all of you, kindly require to provide me support so that a VBA code which should run through col. "H" and where in description doesn't exist number should delete entire row. Therefore that the "1" is heading and the code should run from row. "2" Please see below original data and expected...

Hello, I am in the process of trying to move data within Column 15 of my Excel Spreadsheet to a new row. I will post what the Excel spreadsheet originally looks like and what I would like the end result to look like. I'll also post the Macro which I've put together. The issue right now is...

I want to create a data entry form on sheet1, and then have the information saved to sheet2. I do not want to use the built in Excel forms. The data entry needs to have vlookups that pull in a description, which then needs to be modified and the modification saved off (not the original...

Hi all, I have a document with a column of 400 hyperlinks for different companies. Each link is to a website with a description of each company. The link leads to the same sight and while the description changes for each company the format and location of the description does not change from...

Hello, This is my second thread. I hope it goes as well as my first one in which I got all the help/tips I needed. I am an accountant who loves excel and has come across vba to put my love for excel on steroids. anyways - my boss heard I am good with excel macros (Lie - I am an amateur lol...

Hi Guys, Could anyone suggest me how to find cells containing "ID 1234" or "ID12345" or " ID 123456"? Number could be 4 to 6 digits number. I need to identify from bank statements those transactions, where ID number is given in the description field. There could be the case when description is...

Hi guys, I have a problem with my accounting data analysis. I have two workbooks, let's call them "MAIN" and "DATA". Both are exported from another program, that's why they are in separate files, although they can be on separate worhsheets if there is a need. I have to copy cells from "DATA"...

Hi All, Thanks in advance. i have the below sheet <tbody> S.No. Number Description 1 5 2 3 3 8 Na 4 1 5 7 Na 6 9 Na 7 6 Na 8 4 9 1 10 7 Na 11 6 Na 12 2 13 7 Na 14 8 Na 15 4 16 3 Na </tbody> Now i want the result in fourth column (It will check the...

I am trying to determine the best way to setup my workbook and i keep going back and forth between pivot tables, VBA, and Power Query and can't figure out what is right. I have a data file with a large number of transactions and i want to have separate tabs display a subset of those transactions...

hi all new to the board, I am trying to extract information from one cell into three different cells. My main issue is that not all of the descriptions in the cells are anything alike, see below for an example of seven different part descriptions Description 1 <colgroup><col></colgroup><tbody>...

Hi I use 2 tables, one for entering data and another one for hyperlinking external files based on the data in table No.1 I will show the tables then follow it with the question. Table 1 <tbody> No. Description From To Date Attachment Desc. No. of Attach 33 Excavations Contr1 Owner...

hi im scanning barcodes into A column and want b column to put description of item in column in B I am trying to create a inventory sign out, sign in page for search and rescue Thanks Barry

Help please :) I have a invoice prepared and i am looking to have a part number from a drop down list but then want show in another column the description generated by the part number. Any help would be greatly appreciated Regards,

Hello All, How do I modify formula below to return value with "Description:" in front? Example Value Return = Description: Cooling System Replacement =IFERROR(INDEX('Report'!R:R,MATCH(A1,'Report'!A:A,0))&"", "") Regards, Morey

I am currently configuring a financial report which lists description data as well as financial data. I will post a copy of the layout below. What I'm looking to do, is to use a macro/vba or whatever I need to in order to allow me to create a blank row above any row which contains the word...

I am currently configuring a financial report which lists description data as well as financial data. I will post a copy of the layout below. What I'm looking to do, is to create a macro which would allow me to create a blank row above any row which contains the word Totals. I'd then like to...

Good morning, I have a downloaded file of bank transactions and in the description column, that contains a string of text and numbers, I want to be able to establish whether a customer reference, which could be numbers or text, is part of the description string. So for instance: The...

I am trying to understand how I can create a drop down list that also includes a brief description. For example: Value = 1200 Description = Project Coordination I only need the value but need a description so people know what the value 1200 stands for. Is this something a VBA routine needs...

Hi Sorry if this off topics. I am reading the job description below. I would appreciate if you can answer my questions just to get an idea what is the requirement and where I am at. 1) Validate MS Access databases to align with current excel model My question: Is this Access, Excel or VBA...

Apologies for the generic subject - I didn't know how to sum this one up in a few words. I have a workbook with 2 sheets - 'Sales' and 'Lookup'. The sales sheet is an output from our sales database - the columns of interest are column D (Account Name), Column I (Description), and Column AI...