description

  1. P

    Delete entire row

    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...
  2. B

    Macro to move data to a new row

    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...
  3. A

    Looking for a tutorial for data entry

    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...
  4. D

    Grabbing HTML data from hyperlinks in excel

    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...
  5. T

    Can I Code a macro that has Saved Text descriptions based on a criteria?

    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...
  6. S

    Find ID number

    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...
  7. S

    Copy cells from specific row if the value from another cells match

    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"...
  8. V

    VB Code / Formula - in sheet

    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...
  9. D

    Data workbook with linked subset tabs

    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...
  10. D

    excel extract text from cell after spaces

    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>...
  11. M

    Repeated result based on counter and condition formula

    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...
  12. B

    barcode and description

    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
  13. P

    Having one drop down cell to show two columns of data

    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,
  14. M

    Index/Match: Value Return with additional text in front

    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
  15. B

    Creating a new blank row and moving data to that row

    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...
  16. B

    Macro to create a new row and copy data

    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...
  17. K

    VBA to search a text string to check if a value from a list is part of the text string

    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...
  18. E

    Drop Down with Description

    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...
  19. L

    job description questions

    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...
  20. R

    Help requested with formula

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top