excel & vba 2010

Hi all, Before this, i just get the number for the info that i want, like right now i need the information in column itself. Formula that i used to get the data =COUNTIF(Q:Q,"*"&Apple&"*") so i got 2. I would like to get the output Like "Apple = Apple-Lemon, Papaya-Apple." Means that, find all...

Hello, I have an Excel workbook with two worksheets - MASTER and DELIVERY. The structure is provided below and have same structure; **Doc_number** **Doc_version** **Unit** 43449 01 D013-LAG R 43450...

Hi All experts, require your help for an issue. I have a task to import the members of Distribution list. I am using Outlook 2010 and configured 2 mails. I am able to find and get the members of Distribution List from the first mail box/GAL. The same code is not working to search the second...

Morning guys, I have a column of values containing 3050 rows. Each row has a value from 0 - 50. The majority of cells are 1's, 2's etc. I need to create two new columns to the left, one of which has 50% of the value, and the next having 30% of the value. The trouble is, I've done previous...

i want to create a customize ribbon for workbook specific. so that i can use this ribbon for only that workbook where i created. is there any way on excel 2010. to do this?

I would like my users to be able to hit a button in the spreadsheet and have the Save As dialog box pop up already set to save the document as ta Text(MS-DOS).txt file but still allow them to choose the name & location where the file will be saved. Can anyone help me with the code for this? I...

Hi, First posting on this forum so please be patient with me lol. I will include as much info as possible. My aim is to create an excel spreadsheet that holds numerous (2,500 approx) email addresses in column A of a worksheet called "Email Addresses" in a Workbook called "Distribution.xls" I...

I have tried researching Microsoft's help and googling different boards but I have not been able to resolve this pesky issue. What I am doing is copying two workbooks onto the same worksheet. After the copying is compete I compare the results of the two workbooks and if I get any cells that...

Hi, I want to copy a table from an email in outlook to excel automatically whenever I get a mail with subject "Tasks - <currentdate-month>" using VBA/macros I get at least 10 mails each day throughout the month with the same subject. The email body contains a table in the following table format...

Friends i have a .txt file which contains many columns of data and i want to import only the selected part of data from that .txt file. Is it possible to do that. Normally i first go in data tab in excel then i click on from text button to import the data of .txt file, but this imports all data...

Warm Greetings & Happy Tuesday! :cool: I used Macro Recorder to create module that will insert a pivot table on a new worksheet titled "Invoice Pivot". The source worksheet will always be the same but the number of rows will change. Issues I'm having with this code are...

Suppose a1,b1,c1,d1,e1 are elements of a row and a1,c1,e1,d1,b1 is some permutation of the elements of that row how to retain only one row among all such permutations in several rows and delete remaining I dont know VBA prograoming kind help.

In short, I have a sheet with about 30 different columns in. The order of these columns can vary from month to month. I also have a table which has a list of the column names in, but in a specific order. The following code works fine for one column (I replace CUSTOMNAME with the column...

Hi! I'm using the function target.offset(, 1).value quite often in a worksheet script, so I was thinking that it would been alot easier if it was possible to asign this function to a specific letter, e.g.: set a1 = target.offset(, 1).value so instead of writing "target.offset()... =...

I am creating a macro in Excel 2010 that selects a range of data (which changes each month) and copies that range into a table in Access 2010. I am getting the error message "Run-time Error 2498: An expression you entered is the wrong data type for one of the arguments." The macro stops at...

I have simple but long code as below. I am getting error saying that "Procedure too large". Can someone tell me how to make it shorter or split it? Appreciate and thanks in advance. Option Explicit Private Sub cmdCancel_Click() Unload Me End Sub Private Sub cmdOK_Click() Dim LColumn As...

Hi Guys, I am trying to get this code to work, and just keep hitting my head against the wall not being able to get it to work. Below is the code i have at the moment. It loops over the cells on the sheet, the loops over the combobox list entries, when match is found copies to the sheet...

Am desperately trying to get the below code working (I'm very new to VBA). I basically have a userform with textboxes and a cmd button. The userform opens in one worksheet and I want to paste the data to the last row of a customer list in a different worksheet. The bug starts at the line...

I have a requirement to add change auditing to an Excel 2010 workbook. If the user changes the value of a cell in columns A, B, C, or J, I need to capture the old value, the datetime of the change, the username, and the new value that they enter. I was able to do that - this code captures the...

I have a report that I am trying to print with a VBA script. I need to print the report on one page (portrait) and have it centered. I have the formatting down pat, but the range is causing me issues. I need to set the print range to adjust to the number of values in the named range. Right...