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