vba & excel 2007

  1. D

    VBA Macro to read worksheet and output 10% each category in one column

    Hi All, I need VBA Macro to read worksheet and output 10% each category from one column. Data like this Name IDs A 1 A 22 A 33 A 444 A 555 A 666 A 777 A 888 A 999 A 1000...
  2. A

    VBA to automatically update chart.

    Dear MrExcel community, I have a problem where I am trying to extract values from a dynamic (i.e. input are likely to change) worksheet to specific charts. Now, the dynamic worksheet is my "Data Input" worksheet and I have several chart plots depending on this. What I need, is a smart way to...
  3. K

    Excel VBA Export UserForm ListBox Contents

    I am using the code below to try and export my userform listbox contents to a new workbook. However, I am getting the error as I commented in the code. I dont know where I am going wrong with this code. Need help please! <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit...
  4. L

    Excel macro for Solver

    Hi This is my first post. I’m trying to set up a macro that uses Solver and I have some code below. I was wondering if someone could take a look to see if I’m on the right track. This is what the macro should be doing: Numbers will always be present in one or all of the...
  5. J

    SET DB error Excel VBA

    Hi all. I updated an Access database form an older version and it now has the .accdb extension versus the .mdb. I updated the VB code where it's pointing to the database but getting an error on the following bolded section. Thinking it's because I converted to .accdb. idrive =...
  6. E

    Resize a picture of excel chart and paste into word

    Hi, Hope you can help. My VBA code copies excel charts and then pastes into word doc which has bookmarks. How would I resize the copied chart after it is copied so that it will fit in the area of the doc? Sub Chart_copy() Dim wdApp As Word.Application Dim wdDoc As Word.Document Dim...
  7. S

    how to make duplicate value in other column

    hi all members in the link below i put smal exempl for the resultat which i'm looking for, the idea is how to extract duplucate value in other column. by the way the column F and G has a thousands of values https://1drv.ms/x/s!As8Mdv-a95REhU6iGQZ1-oyfh_Ti excel version 2007
  8. M

    Using Array formula in VBA script

    Hi. I am trying to do a VBA script that automatically selects today date file in a destination folder and uses this in an array formula. When typing in the formula in the sheet without VBA this works. (Ctrl + Shift + Enter) =IFERROR(INDEX('[Deliveries - 13.07.2018.xls]Deliveries -...
  9. E

    VBA code to identify latest file in folder and copy contents to another workbook

    Hi. Hope someone can assist with the following. We have a shared folder where csv files are dropped on monthly basis. I need to identify the latest files with name File1 and File2. The file name changes each month as it ends with the month it is produced e.g. File1Feb18, File1Mar18...
  10. F

    How to Filtering through a column's cells and put certain data in a different sheet using VBA-Excel

    I am working on a macro. That will select a column, search every cell of that column. in those cells data sample are like this. BQ43BI BQ38AV BQ64BH BQ49AW BQ51AA BQ44BE BQ49AA BQ49BE BQ52AA BQ28BJ BQ39Z BQ40X BQ61AB BQ57AJ Now i want to...
  11. D

    VBA to Paste values if condition met

    Hi All! I'm looking for VBA code to copy and paste values in the range D37:F54 in the below example, but for only the rows that are not sub-totals (i.e. paste values for accounts that do not start with a "PL") Right now all rows have formulas in them that populate the data from somewhere else in...
  12. M

    VBA auto record macro change help required

    Hi, I need some help in below code. I recorded the macro and this code generated. It should save file in same format at the end that part I deleted because it asked for xlsm format so I did to get the code. What I was doing in this code is basically. 1. Filter "Pending" "Mobile" Status in...
  13. C

    Delete row that are later than 4 quarters, excel stops responding after VBA code runs

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...
  14. P

    VBA Count maximum occurance of a value in a row

    I need to write a macro that searches a specified column and counts all the cells that contain a specified string, such as character "p" and character "q" then associate this in another column specifying how many occurrence of "p" and how many occurrence of "q" in a different column. Have...
  15. J

    Excel 2007 Automatically Turning on Design Mode When Saving and Exiting

    Ok, I have a weekly revenue report that several managers must complete each week. It uses command buttons to guide them through it with userforms. Long story short, 2 managers are using Excel 2007 and it keeps turning on design mode when they save it and exit. Some things I've done: Saved...
  16. M

    Link update within formula Index Match function

    Hi, I am using following formula in a cell to get data from another workbook. The formula is {=INDEX('D:\Offical\Calculation.xls]Sheet 1'!$B$2:$B$598,SMALL(IF('D:\Offical\Calculation.xls]Sheet 1'!$D$2:$D$598=L$3,ROW('D:\Offical\Calculation.xls]Sheet...
  17. D

    VBA to find value

    I am using VBA to do some clean up to a work sheet after users enter some data. Every sheet is going to have only one instance of the following cell combination: <tbody> Some number T </tbody> So I want to find the value in the cell to the left of the one cell with a T in it, produce a...
  18. A

    vba to fetch email id and send emails automatically

    Hi I am trying to create a macro to send emails automatically via outlook. Currently i have the raw data which i have sorted according to the Send code mentioned below ,separated the sheets based on the account field. Now i need a code to send email to specific email id based on the send code...
  19. A

    Display only columns with certain text

    Hi all, Please teach me how I can display only columns with certain text in Excel 2007? There are a lot of help on filtering rows but I am hoping to create either a toggle button or set up a reference cell (say "B4") along with a VBA to display columns with selected days only. For example...
  20. D

    VBA to create LineMarkers chart from dynamic rows and fixed number of column

    I have a worksheet named "Summary". Column "A" to column "Q" have variable numbers of data. The number of rows are not fixed(dynamic) for a column. Also Sometimes one or more column are empty or all the cells in a column have missing data. Now, I want to create a LineMarkers chart from each...

Some videos you may like

This Week's Hot Topics