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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top