support

  1. mikerickson

    New computer, new Office

    Hi folks, I bought myself a new Mac Book. My old Office 2011 is out of installs and it looks like Office 2019 is where I'm going. But I do have a couple of questions. Does anyone who has experience with 2019 know if: 1) does it support VBA (in memory of 2008 :) ) 2) is the MacScript command...
  2. H

    PDF Manipulation in VBA

    This my be outside the scope of this messageboard. I have a number of automation processes running many reports and such. One of the tasks that needs to be done is to save an word file as a PDF. This is, of course, trivial in VBA. However... What I really need to do is use Acrobat DC ability...
  3. B

    Does Access support pivot tables now

    Hi, I am new to MS Access. I wanted to know, does Access support Pivot tables now. I am required to edit couple of existing macro. These macro has pivot tables in this. However, I guess, pivot tables are no longer available in Access. Please correct me if am wrong. How do I proceed if pivot is...
  4. B

    Find duplicate in row based on cell value.

    I'm looking to highlight/identify duplicates in a row based on a common title (same) and am not sure of the direction to proceed. Simple example: There are two helpdesk title's and both are part of similar groups. I would like to identify all groups that "helpdesk" have in common. Then...
  5. P

    Run VBA/Macrom from another file

    Hi to everyone, kindly require to provide me a VBA code so that to run a code from another folder/file. The bath of the code is follow: w:\accoffice\inv.people\VBAacc.xlsm.personal.XLSB!moduleacc Please note without opening the file It would much appreciate any support. Thank you in advance
  6. D

    Help - Slow Performance on File (Experts Needed)

    I have an issue with a Gantt Chart Template that I created, its very slow for some reason (I cant find the root cause :warning:) Could you please take a look of it and support me to speed it up? Thanks a lot!!! Download Link: https://drive.google.com/open?id=1nU...nDEKAB0iePAH6a
  7. B

    Date Formula Support Needed

    Good afternoon all, I'm looking for some help with a BI Power Query formula (Trying to cut out lots of manual work) that will take a date from a column (So 10/07/2019) and return back whether that date was Last Week, Last Week -1, Last Week -2, etc up to Last Week -4 in a new column to the right...
  8. K

    How To Sum A Column Against Each Unique ID With Multiple Conditions

    Hi, I have a sample data as below, original data is around 90 thousand. Please Note:- That in the below sample data the value in the column "Approval Status" is show "Approved", but this is not the case it can be other values as well for example like "Rejected" or "Submitted" etc., Sample...
  9. A

    transfer data in order

    Dear supporters, appreciate your support to help me i copy data from system to excel sheet (data) <colgroup><col></colgroup><tbody> A - Support A - Support A - Support B - Support B - Support B - Support B - Support B - Support B - Support C - Support C - Support C -...
  10. B

    How to deduct one row

    Hi All, How do you deduct 1 row from the last row selected using ctrl+shift+down? In this way, I won't be including "Grand Total" to the graph that I will be creating. Range("A5").Select Range(Selection, Selection.End(xlDown)).Select <colgroup><col width="305" style="width: 229pt...
  11. B

    Automate the creation of graph from Pivot Table - VBA

    Hi All, I have created a VBA that automatically creates a pivot table. However, I would also like to automate the creation of a graph from the the pivot table. What I want to happen is to make a graph from the details without including "Row Labels" and "Grand Total". If there is a new entry for...
  12. B

    Remove Blanks from Pivot Table VBA

    Hi All, How do you remove a row with "(blank)" from a pivot table which is also producing count for blanks? VBA <colgroup><col width="305" style="width: 229pt; mso-width-source: userset; mso-width-alt: 9760;"> <col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt...
  13. M

    Convert Excel to Vba Code msxml2.xmlhttp

    The code I wrote is also slow to take data from the site so I want to translate it to msxml2.xmlhttp. I need your support for it, if you help https://yadi.sk/i/DtV6aex_1I2lxQ <svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"> </path></svg><svg focusable="false"...
  14. M

    Excel Transpose Help

    Hello, I a have a spreadsheet of about 1600 rows in which I need to get into another format.... <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Part ID Amount 79123 5233122 44.18 79123 11606476 95.1 79123 22346192 149.81...
  15. T

    Time to Text

    Hello. I am trying to concatenate two cells that contain time of the day and show them as a time slot in text format (like: 09:30-11:00). I have changed the destination formats to text and also used the TEXT formula but it returns strange numbers (fraction of 24 hrs I assume). How can I change...
  16. M

    Replacing () around numbers of varying length, in text thread of varying length

    This one is baking my noodle. I need the digit in () extracted into a separate column. These are all values in Column A, though some columns are indented. Ideas, please?? 01. First Week (1) None (1) 10/09/2018 (1) Initial Onboarding Complete 01. First Week (1) None (1) 07/30/2018 (1) Initial...
  17. JenniferMurphy

    Does VBA support keyword parameters?

    Does VBA support any kind of "keyword" parameter? By this, I mean parameters of the form keyword=value. Something like this: =MyFun(A1, B2, Keyword4=C3, Keyword2=D4, ...) I am working on a UDF that has half a dozen optional parameters with more to come. Most of them are omitted on most...
  18. C

    SUMIF - Based On Unique Values and Multiple Criteria

    Good evening all, I was wondering if someone would be kind enough to help mewith the following please? What I am trying to achieve is the following: Retrieve the gross balance for all accounts (excludingduplicates where there is >1 of the same entry / account) in Column A whilstalso...
  19. J

    Multiply rows

    Hi guys, Sorry to bother you, but I don't know if Excel is able to do this task, if yes it would be great. :) The thing is I have, for example, a list of values (1,2,3,4,5) and another list of values (A,B,C), is there any way, having this, to get these row combinations?: <tbody> 1 A 1 B...
  20. N

    Number format... Help !!!!

    Hi, I have a report and in that the format of the number are coming in 2 different ways. Is there a way to correct this. 1. 340.35 = this is normal format, i don't have any issue with this. 2. 28.390,26 = If you could see there is "." instead of "," and "," instead of "." and also have to...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top