# Tagged Questions

**0**

votes

**1**answer

36 views

### New instance of Excel does not see already opened instance

I have Avizo.xlt with one Worksheet and a code which intended to put this WS inside already opened document, which is SLK report made by our ancient ERP system, and close this document.
Everything ...

**0**

votes

**1**answer

85 views

### Show or hide rows in an excel sheet subject to the value of a particular cell (excel 2007 & Windows 7)

I have made a spreadsheet to specify decoration selections from a range of standard options.
There are five separate ranges so this is the first selection then within each range there are additional ...

**0**

votes

**1**answer

48 views

### Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100.
On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...

**0**

votes

**1**answer

78 views

### VBA Excel: Function to find a string in another workbook

I'm trying to create a function that searches a string (bom) in two different workbooks and returns a value next to that string. I know the ranges in those workbooks where I want to perform the ...

**0**

votes

**1**answer

48 views

### VBA Excel: How to select only numeric values in a range?

I used Range.Find to locate a string called "Qty", now I want to select all the numbers in that column.
I would use .End(xlDown) to get the last row, however the last used cell in that column is not ...

**0**

votes

**1**answer

60 views

### Deleting entire row in excel if missing data in certain column or columns?

I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...

**0**

votes

**1**answer

85 views

### VBA string search within files in directory not working in Excel 2007

I'm trying to look for a string within a folder containing several files. Once the string is found it should select and copy a value in an adjacent cell 5 columns to the right(Offset(0,5)), then paste ...

**0**

votes

**0**answers

55 views

### I'm looking to create some VBA code to search for other instances of certain string, move original instance above found

Please excuse me if I'm posting incorrectly in any way- this is my first go round on superuser.
I'm looking to create a fairly basic VBA macro to automate a process in excel I'll otherwise have to ...

**0**

votes

**0**answers

78 views

### how to convert data in table format to pivot format

I would need help in converting table which is in table format to a pivot format. Below is the sample data which i have:
![Input File][1]
Product Currency Value US UK Japan Ind ...

**0**

votes

**3**answers

55 views

### Combine rows in Excel

I have data in column 1 and data in column 2 as follows:
1234 eggs
1234 bacon
1234 toast
4321 Orange Juice
I want it to appear as follows:
1234 eggs-bacon-toast
4321 ...

**1**

vote

**1**answer

84 views

### Need a Excel script to identify email addresses that contain a different variation of the first name of the contact

I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc.
We are basically trying to ...

**0**

votes

**0**answers

228 views

### Fill a web form with data from excel (macro)

I am new to VBA and I am struggling to find a solution for my problem. I have an excel database with UNs and PWs for a number of profiles. I also have an administrator UN and PW and each time I want ...

**1**

vote

**1**answer

95 views

### How to access the formatted text within an Excel cell with VBA

I have embedded formatting within an excel column. For example, a cell might contain some (but not all) italicised words.
The .Value, .Value2 and .Text properties seem to strip any formattting.
I ...

**0**

votes

**0**answers

31 views

### VBA Editor on F8 shows outlook insted of Step Into

Excel VBA Editor on F8 shows Outlook insted of Step Into. I don`t use it and it wants me to add my e-mail configuration every time. In other applications F8 works properly. What am I doing wrong?
...

**0**

votes

**0**answers

34 views

### Excel Macro looping

I used this macro and it worked fine, but I needed a little bit more.
I had to change LookAt:=xlWhole to LookAt:=xlPart and add the color formatting. Now, when I select a column, the Macro appears ...

**0**

votes

**0**answers

34 views

### Excel: Automatic data transfer when excel workbook updated

I'm wanting excel 2007 to automatically identify and transfer the new rows of data from one teams spreadsheet to our own.
Is this possible within excel? I envisage a macro would be able to compare ...

**1**

vote

**2**answers

236 views

### Excel formula/VBA to detect a property of a group of rows

I have a large dataset in an Excel sheet where:
column A: quote number
column B: opportunity number
column C: sales order number.
One quote number will have multiple opportunity numbers. A sales ...

**0**

votes

**1**answer

269 views

### locking cell of dynamic sheet based on value range

I want to use the Excel sheet for Dynamic purpose.
Various product numbers that come from scanning barcodes need to be entered in column A. I want to ensure that if the product number entered ...

**0**

votes

**0**answers

401 views

### Using VBA how can I reassemble Excel worksheets in different workbooks while maintaing the format?

I am struggling to complete this code successfully.
Basically I have a master workbook which has defined range names. The first range is the header followed by a number of ranges (section1, section2. ...

**0**

votes

**0**answers

112 views

### Excel4Mac - can't find my VBA modules?

I have an Excel sheet with several macros, coded on a Windows machine. I used to keep the file in a dropbox folder for easy sharing with my home computer, which is a mac.
I never had any problem ...

**0**

votes

**1**answer

2k views

### Expanding only selected rows in Excel using VBA Macros

I have written the following VBA code that contains a condition where if the Cell#="Yes" then expand the bottom row, else if Cell#="No" then collapse the bottom row.
Private Sub ...

**2**

votes

**1**answer

246 views

### Macro to merge cells in a column if the same rows are merged in a different column

I need help finding a macro that can merge cells across rows in a column if those same rows are already merged in another column. Below is a screenshot of what I have now that shows the cells that ...

**1**

vote

**2**answers

864 views

### How to combine values from multiple rows into a single row

I have an Excel 2007 spreadsheet with 2250 rows and 19 columns. In these rows, I may have two rows of duplicate customer information that need to be combined, but only if the cell above is empty. I ...

**3**

votes

**1**answer

121 views

### How to automate transforming a table into a matrix

I've been looking for a way to automate transforming data in an Excel table into a matrix.
For example, from the left table into the matrix on the right, as shown in the following image:
Apparently ...

**-1**

votes

**1**answer

256 views

### Is it possible to build a cumulative formula that will sum on new worksheet added daily?

I have a worksheet that the user opens each day and clicks a button that copies the current sheet to a new sheet and renames (Day 1, Day 2, etc.).
I want to keep a cumulative count in some of the ...

**2**

votes

**1**answer

84 views

### Excel visual basic function across workbooks?

This seems like it should be a common issue, but I couldn't find anything on it, maybe I'm just searching for the wrong thing.
Basically I get sent a lot of workbooks that need specific modifications ...

**3**

votes

**2**answers

4k views

### How to implement MATCH and INDEX functions together in Excel VBA?

I am trying to find the row number of the first cell that is less than zero.
So, by browsing through the net I was able to come up with this formula which works perfectly fine:
...

**1**

vote

**2**answers

420 views

### Passing Range to ABS function in VBA

I would like to perform a function which looks like this
Selection.FormulaArray = "=GEOMEAN(ABS((C646:E646)))"
Since my range keeps varying I would like to pass the range as a variable which looks ...

**1**

vote

**1**answer

185 views

### Office 2007: How to sort an Excel Table from within a Word macro

I have written a Macro in WinWord2007 which lists styles and their properties in an Excel table. The table is made accessible by the following 3 lines:
Dim Oxl_Sheet As Object
Set Oxl_Sheet = ...

**0**

votes

**2**answers

981 views

### How can I turn a Calculated Column back into a data column in an Excel Table?

I have a large Excel Table (44 columns, 1000+ rows), but one of the columns has been accidentally turned into a Calculated Column (See Here). The result being that now when the users try to add new ...

**0**

votes

**1**answer

704 views

### In Excel 2007, in VBA editor, why when I type Worksheets(1). , Excel does not list the members of the Worksheet object? (and how to fix this)

The picture that explains the question:
Notes:
I have Tools: Options: Auto List Members option selected
Ctrl+Space fails
I know that I can use the Object Browser to see, what members I can use ...

**0**

votes

**1**answer

210 views

### Find duplicate rows based on two columns and transfer results into another worksheet

I have a worksheet ("Saisie de Données") containing data in column B and D that are sometimes duplicates. I would like to be able to recognize these duplicates and sum the data in the columns G to V. ...

**3**

votes

**1**answer

786 views

### “The visual basic for applications (vba) macros in this workbook are corrupted and have been deleted”

Recently, I found an Excel 2007 Macro Enable Spreadsheet are keep getting the following error message:
The visual basic for applications (VBA) macros for this workbook are
corrupted and has ...

**1**

vote

**0**answers

39 views

### Excel ran out of resources while attempting to calculate one or more formulas [duplicate]

Possible Duplicate:
Excel ran out of resources while attempting to calculate one or more formulas
I received the error message
"Excel ran out of resources while attempting to calculate one ...

**2**

votes

**3**answers

7k views

### Excel ran out of resources while attempting to calculate one or more formulas

I received the error message
"Excel ran out of resources while attempting to calculate one or more formulas"
on ONE of my computers (Out of 2).
My worksheet contains: (Inside a single worksheet, not ...

**2**

votes

**1**answer

498 views

### How to copy the network path of the open workbook in Excel 2007 to the clipboard?

I want to write a VBA function for Excel 2007 (as well as Word 2007 and powerpoint 2007) which:
copies the complete network path of the open workbook or file to the clipboard.
I'm working a lot ...

**2**

votes

**3**answers

2k views

### How to store VBA Macros for Office 2007 to have them always available and share them with others?

I have created some useful VBA macros for Word, Excel Outlook and PowerPoint 2007.
Now I want to
have them always available in the corresponding application via keyboard shortcut or icon to click ...

**0**

votes

**1**answer

1k views

### 'Subscript out of range' error when selecting a range

I'm getting a VBA error (Run-time error '9': Subscript out of range) when I am trying to select a workbook and then a cell within a sheet in that workbook.
this_workbook is correct, and copying and ...

**0**

votes

**1**answer

362 views

### MS Excel find and replace macro

I have written a macro to remove special characters in a sheet based on ascii values but the problem with it is that it is replacing the cell content. For example p;j;h which should become p,j,h is ...

**1**

vote

**1**answer

80 views

### How can I select a cell by its content?

Is there a way - either manually or with vba - to select a cell with the input as its content?
Lets say I want to go over all the cells that have a content of XX (like find)
so I would do like in ...

**1**

vote

**1**answer

378 views

### Sum up, then delete

I am trying to sum up all the values with the same invoice number to the first row that contains that invoice number. After which, deleting the rows that have the same invoice number that are below ...

**2**

votes

**1**answer

591 views

### How can I combine values from multiple rows into a single row in Excel?

I have a result in Excel that consists of customer's invoices and payments. The data are on a separate row for every invoice and payment which looks like this:
I would like the invoice and payment ...

**4**

votes

**1**answer

999 views

### How to use the autocomplete feature for VBA function in Excel 2007 with Excel Add-In

(cloning from question on SO)
I created a function in VBA. I want Excel 2007 to show the Autocomplete when writing this function in the cell's Excel.
Detail as
How to use the autocomplete feature ...

**0**

votes

**2**answers

497 views

### VBA editor to open a module instead of a class module on startup

In my Excel file, i have both a module and a class module. When i open VBA editor, the class module's code loads into the main window and if i want to see the module's code, i have to click on "+ ...

**3**

votes

**1**answer

2k views

### Show Excel column filter information in cells

We have a sheet with a huge number of columns and filtering is often used to navigate to the correct data. The problem is that sometimes its not obvious that the filter has been applied , the visual ...

**4**

votes

**1**answer

176 views

### Excel “super duper” vlookup formula needed

If I have the following data:
123, thomas
123, gordon
123, smith
334, joey
334, nancy
3452, angela
3452, liza
I want a formula to produce the following results:
123, thomas, gordon, smith
334, ...

**0**

votes

**1**answer

837 views

### How to password protect multiple Excel 2007 files with multiple passwords using a Macro?

I'm new here so please let me know if my post is incorrect or anything like that.
I currently have a macro that splits out one excel file into multiple files and saves them separately. This step I ...

**1**

vote

**1**answer

255 views

### Convert To Range - dynamically grab tablename

I found the following post on this site.
ActiveSheet.ListObjects("TableName").Unlist
Problem is that I get different tables and I don't know the tablename. I know that A2 will always be a part ...

**3**

votes

**7**answers

19k views

### Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel:
How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...

**6**

votes

**4**answers

33k views

### How to combine values from multiple rows into a single row in Excel?

I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this:
...