vba & excel 2007

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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