vba & excel 2007

  1. smide

    VBA to extract only number from a cells in Excel report

    Hello. I need some assistance with an excel spreadsheet which contains very raw output report in row 1 columns (A-ZW). In row1 in Sheet2 I have a raw report output which contains certain Products id's. The problem is that I need to find cells that contain this data about product's id's, then...
  2. smide

    Macro ClearContents specified range cells on multiple Workbooks

    Hello. I'm currently using the following code to clear cells in a Sheet2: Option Explicit Sub Clear() Worksheets("Sheet2").Range("A1:Z50").ClearContents End Sub However, since I have about 30 Workbooks (all in the same folder) I would like to clear contents in all of them (range A1:Z50...
  3. smide

    VBA to copy values based on identical text strings in cells and remove duplicates

    In Sheet1 (starting from row3, A-X columns) I have a data summary (product's mark and product's prices) and Sheet2 is only for the raw data. Product's mark is characteristic which contains one to six letters (always to the left of price). I need a Macro to copy/append data from Sheet2 to...
  4. smide

    VBA - need help to add another feature into existing code

    Hello. The following code allows me to copy data from Sheet2 into Sheet1 and at the same time to remove duplicates based on the same text in columns A,C,E... So, for example, if macro finds that the text in cell C9 (Sheet2) is the same as text in any of the cells in column C in Sheet1 he...
  5. A

    Data Consolidation from Multiple Files

    Hi All, Here I go again requesting for help. :(:( So I have multiple workbook, which will be the dump file of the userform I made. basically what it do is track activity of each employee. This workbook called TALTracker has in itself the userform. when you open the file, the userform pops out...
  6. A

    VBA Code To Consolidate Data from Multiple Workbooks

    Hi All, Here I go again requesting for help. :( So I have multiple workbook, which will be the dump file of the userform I made. basically what it do is track activity of each employee. This workbook called TALTracker has in itself the userform. when you open the file, the userform pops out...
  7. A

    Unlocking Columns after VBA Code

    Hello. I am a noob to excel vba. I found this great code that gives me part of what I need. However, I do not want columns C & F locked after entry. I've tried a few things, but it's not working. Can anyone help? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents...
  8. S

    Help Copying Data From Closed Workbook Using Input Box

    Good Morning, I have two Workbook's Quick Test1.xlsm(Source) & Test.xlsm (Destination) , i would like to have a button on the Test.xlsm Sheet "Master" that once clicked prompts user to search for a client name, it will then search the closed workbook Quick Test1.xlsm Sheet "Companies" for the...
  9. A

    Runtime Error 380: Could Not Set the RowSource Property. Invalid Property Value

    Hi All, I am a newbie in VBA and was trying to create a userform that will allow me to track what my people are doing. it compose of parts where data should be inputed. One part is choosing between options in combobox. The chosen option in combobox1 will dictate the list of items available in...
  10. S

    Need VBA help with variable quantity mail merge lables

    Hello, I have a large inventory list I've created in excel. I need a macro to create X number of labels from data in the table. It has 13 columns and a running number of rows. I've been looking around for a few months now but haven't found anything that works for me. Is this even possible? does...
  11. W

    VBA codes could not run in marco enabled file type

    Sorry that I am new to VBA, thanks to all the experts here I am able to copy some of the codes and modify them to suit my needs. Basically, they are just a couple of command buttons which carry out various functions. It work out fine in my excel 2010. However, when I try to save the file in my...
  12. P

    Sorting cells with two criteria

    Hello, I have a program that queries large amounts of data from a server depending on what dates the user inputs. I have to plot this data from largest to smallest comparing it to a percentage which is in the column the left. The data returned has a variable number of points so the percentage...
  13. L

    Applying array formula to range VBA

    Hello, I am trying to apply the following array formula to a range in Excel: =IFERROR(INDEX(AllFiles!A$2:A$1000000,SMALL(IF(AllFiles!$C$2:$C$1000000=$A$2,ROW(AllFiles!A$2:A$1000000)-ROW(AllFiles!A$2)+1),ROWS(AllFiles!A$2:AllFiles!A2))),"") using the following methods that I found online (I'm...
  14. W

    Help Transitioning Formula to VBA

    Could someone please help me translating the formula below into VBA coding? I would like if all of these cells were pre-populated behind the scenes. =IF(SUMIF($T$12:$SF$12,"<="&EOMONTH(V$12,0),$T14:$SF14)<=$K14,V14*$J14,(SUMIF($T$12:$SF$12,"<="&EOMONTH(V$12,0),$T14:$SF14)*J14)-$I227) My range...
  15. V

    VBA/Macro to update excel 2007 web query

    Hi Guys Good Evening, I am completely out-of-energy, looking for an answer to my questions on internet since last one week. Found few of those. Since I am a non-IT person, I was not able to find/identify the complex ones. please help me. Question - 1 The columns B, C, D and E has a web query...
  16. D

    Finding data in closed workbooks with VBA

    Hi all, I'm wondering if it is possible to scan through a number(15) of different closed workbooks (containing 1 worksheet each). if the value "Fail" is found anywhere in the workbooks I would like to copy the entire row and paste it into the active worksheet, called "Summary". I have...
  17. C

    VBA for replacing cell value on another sheet

    I am new to the VBA game so I am having some difficulty with the following situation. I have a data set format outlined below. I need to create a macro that can update a value on the data set given constraints of Month and Year. For example: Month | Year | Value Jan | 2014 | $400 The form...
  18. F

    Enabling the Total Row via Macro

    Hello, I've built the below Macro to take information from one sheet and put it into a new workbook as a Table. Problem is I need to add a total row and when I go the usual route of 'ActiveSheet.ListObjects("Table1").ShowTotals = True' I get 'Run-time error '1004': Application-defined or...
  19. J

    Count Number of Selected PivotTable Filters

    Good afternoon folks! I have another tough question. I have a PivotTable Report Filter that I want to Count the amount of selections in that filter preferably via VBA but a formula would work ok too. So for a Person's Name, there's a filter under it for Dates and I'd like to be able to count...
  20. K

    VBA: method union of object _global failed

    I am trying to filter out the rows having the cells in a particular column (the 'O'th column) with the value "Desired". For this I've written this code Set PTRange = ThisWorkbook.Sheets("DumpData").Range("A1:AD1") Dim frow As Long frow = ThisWorkbook.Sheets("DumpData").Range("O" &...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top