macro's

  1. G

    Changing the subtitles stops VBA working and form printing

    Hi, I already have a sheet set up with an embedded form that pulls data from the spreadsheet and prints using a button programmed to print each numbered entry. A second button also saves a pdf copy to the system. However I need to change the subtitles in the spreadsheet and form as they have...
  2. B

    Extracting Alt Enter data by Creating rows underneath using macros

    Hello All, Ok so here is my data set -- removed inline image --- Top is what I have, bottom is what I need. Is there a Maccro way to do this? I tried using text to columns using the Alt H command to bring the data out, then indexing it down and that works for doing it 1 row at a time, but...
  3. A

    Excel applications in SharePoint

    Hi All, I have created an excel application which analyses some data held in SharePoint via a SharePoint list. It then creates an excel export and closes the initial workbook. I have tried uploading this to SharePoint for use however this causes no end of errors which did not occur when i...
  4. A

    Autofilter method of range class failed

    Hi, I am trying to write a macro which takes data input into a userform and runs various autofilters based on this. A particular part of my code is triggering a Autofilter method of range class failed. The code is If RB1_chk.Value = True Or RB2_chk.Value = True Then WSE.Activate...
  5. A

    Pivot tables - multiple consolidation ranges

    Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I’m having issues with a pivot chart which has source data from multiple consolidation ranges. I have 4 sheets with data in them, 5 columns in total (A:E), all 4 sheets have exactly the same format...
  6. A

    adding question numbers

    Hi, I have a macro which produces a worksheet of specific questions according to what criteria a user choses on a userform. It then copies this data into a new tab. There are 3 columns, Question Number, Question and Evidence. My problem is that because the data copied is a mere extract of a...
  7. A

    Is it possible for a macro to search for a phrase and export if true?

    Hi, I have a large sheet which tracks initiatives. I would like to write some code so that a user can click on a button which opens a search box, they can then enter a phrase. What the macro will do is search the data (Columns A-AA) and where it finds a match in text to the phrase it exports...
  8. B

    always turn on macro's

    Hi, Is there a way to always turn on the macro, even if you push the (left) button to turn off the macro's? Regards, Bengtar

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top