vba & excel 2007

Hello, I have sheets with article numbers # and a corresponding result X for these articles. In another sheet there are limits set for each article number. I would like to compare the result X with those limits and highlight them when the article number # matches.

Hi, im trying to set a workbook and worksheet in vba so i dont have to keep referencing the sheet name in my code here is my code is there a way to make it where i dont have to keep typing "sheet1" Sub Get_data() 'allow the user to select an excel file Dim FileToOpen As Variant Dim...

Private Sub CommandButton1_Click() a = InputBox("Enter the Row", "Excel VBA Says", "Please enter data") Rows("a").Select Selection.Copy Selection.Insert Shift:=xlDown Range("L8").Select Application.CutCopyMode = False Selection.ClearContents Rows("a" + 1).Select...

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...

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...

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...

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...

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 =...

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...

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

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 -...

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...

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...

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...

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...

****** 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...

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...

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...

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...

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...