data ranges

  1. B

    Excel VBA error with sum formula

    Hi All, I have an spreadsheet which consist of employee data and there revenue to generate an automate invoice. here is an image link https://1drv.ms/i/s!AnOR9mvtWzlzc6NUs4vHUtxOI5c M21 is the total cell which has name range as Total M22 is the StTax as name range. The grand total has...
  2. W

    Struggliing with relative / variable filenames and data ranges.

    All I want, as with so many macros; I just want them to run on the ActiveSheet, regardless of it's name. I can even use ActiveSheet.Name to print a popup of the actual name of a particular Workbook/sheet, so I know the Macro knows what the name of the document is, but in no way can I include it...
  3. R

    Excel Question - Autopopulate a Table with Date Ranges

    I have a question...I am bulding a table in Excel which contains on the columns all of the months and in the rows I want to display in automatic the information from another table that I have with all of my contracts (3, 6, 9, 12 months contracts), so basically in my first table I have all of...
  4. R

    formula to expand ranges

    I have several entries in a column of data... example: t334.1 - t356.9 b044 - b059.7 w120.88 - w129.55 1036 - 1048 1044 2233 239 19 12567 H0876 I'd like to know if it's possible to "expand" these "ranges" to include the lines not shown (and represented by) the "-"... example 2: same list...
  5. A

    Send outlook emails with message in cells to individual emails associated with them

    Hi everyone, Basically I have a data sheet with a list individuals in one column and individual messages in the next and their associated email addresses in another. I have an excel VBA code which sends the whole worksheet as an email attachment to a specific address. Is there a way to modify...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top