1. T

    For Each Loop

    Following from this thread: I was told this piece of information: Syntax ... For Each element In group ... element ... For collections, element can only be a Variant variable, a generic object variable, or any...
  2. A

    Filter dataset with multiple parameters

    Hello there, this request is far beyond my capabilities of excel and I'm hoping that it can be done. I have a dataset as an example below: <tbody> A B C D E 1 <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Email address <style...
  3. P

    Case "Question"

    Good Evening, I have a Case code question. In having: Case "Tab Name" Now the represents just that, the name at the bottom of the tab of which is the actual name of the worksheet. Is there anyway to specify this in a generic fashion? For example...
  4. S


    My company has upgraded to Excel 2019, and I previously used a morefunc plugin which no longer seems to be compatible. Specifically, I'm getting errors with SHEETOFFSET, which I believe was part of morefunc. I have found a few examples of SHEETOFFSET online, but they are all different, and so...
  5. M

    Creating generic update statement

    Hi All, I'm trying to load data from excel to sql server. For this I created an insert statement which is very generic means this statement can be used for any table. I just have to change the name of the sheet and it will automatically pick up the names of the columns and their values from the...
  6. D

    Removing generic date value within formula

    Hello all, I've written a formula that removes the time stamp and time zone for a date value. Wherever the date field is blank a generic date is placed there '01/00/1900'. I would like to replace the generic dates with a blank instead. The formula I'm using is...
  7. S

    Send email from a selected cell value using VBA

    Hi I have a macro which emails a report out to users based upon various details which is working as expected. The one issue I have is that I would like to be able to select a value in a cell that is the email address the message is to be sent from. At present the email will always come from my...
  8. F

    Tab Insert Message

    Hi I get this message on a number of workbooks and want to try and stop them, anyone know why this happens and how do I stop it The name 'Generic name' already exists. Click Yes to use that version of the name, or click No to rename the version of 'Generic Name' you're moving or copying I...
  9. S

    Amalgamating data with several lines

    Hi All, I need to amalgamate some data I've got but my minds gone completely blank. The name is all one person but I need all the types to come into one Cell. I'd normally use concatenate but some people haven't had all the tests so the data isn't consistent. Some have only had 2 parts..I...
  10. M

    VBA? to create unique records from list

    Hello, I would really appreciate some help. I have a spreadsheet with 19 columns. In column A there is a generic code In Column K there is another generic code In column D there is a quantity A D K (qty) ABC 1 123 XYZ 2 123 DEF...
  11. S

    Identify generic comments

    I have a list of comments that is manually entered by multiple people. I need to find which is generic in nature. Is this possible in excel. i know we cannot use any formula for this. Is there a way to do this using macros?

    Macro to sort across multiple sheets and remove duplicates

    I have a workbook with multiple sheets of data and all are in the same format (data with the same headers in columns A:I). However, the number of rows with data is a variable - different for each sheet. I want it to sort column A ascending and column I descending, and then remove duplicates -...
  13. 1

    Macro - use on one current worksheet (i.e generic name ref)

    This is likely to be an easy challenge for most of you experts: I have a very helpful macro which I generated via "Record Macro". I want to be able to run it on ANY similarly structured worksheet. Alas, it appears to have the original sheet name embedded (see code below). Can I replace the...
  14. E

    sort generic selection with macro

    Hi all, I want to create a macro button to sort whatever range I have selected according to column D.... For example, I want ONE sort button that works when I select B7:H9 and it to also work when I want to sort B10:H11.. I do not want it to sort the whole table at once, or it will pull...
  15. R

    Generic Macro

    Let me describe my situation. I have 2 xls files. Lets call them info<date>.xls and database<date>.xls I have to update both files on a weekly basis. Here are my current steps: 1. Manually update stuff in info<date>.xls and save with today's date, leaving the older file unchanged for archival...
  16. L

    Excel Macro to remove all row fields in a Pivot

    Hello, Is this possible? I know how to do it if I'm trying to remove specific row fields by name, but is it possible to have a macro just remove all row fields regardless of name? Thanks!

Some videos you may like

This Week's Hot Topics