0
votes
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
3answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
3answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
7answers
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
4answers
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: ...