-1
votes
1answer
18 views

Deleting range of cells based on criterea

I have an Excel file with several macros, used for data processing. The masterfile reads one or more .csv files and copies all data it needs into a tab (lets call it sheet1) within the masterfile. ...
0
votes
0answers
18 views

Replace multiple words in Excel sheet

Sub xLator2() Dim s1 As Worksheet, s2 As Worksheet Dim N As Long, i As Long Dim from(), too() Set s1 = Sheets("Sheet1") ' contains the data Set s2 = Sheets("Sheet2") ' contains the translation ...
1
vote
1answer
52 views

Find and replace multiple words in a column in Excel 2007

Sub xLator2() Dim s1 As Worksheet, s2 As Worksheet Dim N As Long, i As Long Dim from(), too() Set s1 = Sheets("Sheet1") ' contains the data Set s2 = Sheets("Sheet2") ' contains the translation ...
2
votes
1answer
41 views

Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following: = A1 + A2 = B2 + B2 etc., ... I would like to replace each of these cell references with the values without ...
2
votes
0answers
46 views

copy data from multiple word files to excel with vba

I know this question was already asked (Copying data from multiple word docs into one excel sheet) the thing is I can't use the answer. I'm fresh to vba, but I thought I can handle it. I was wrong. I ...
0
votes
0answers
34 views

VBA Code to update data in closed excel files within a folder by clicking a button

I have a code which works really well that updates values of closed excel files in a workbook. What I want to do is alter the code so I can create a on my worksheet where I can make y changes I ...
0
votes
1answer
27 views

Excel 2007 VBA Export range as jpg file is trucating picture

I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by other application. Below is the example of code that I'm ...
0
votes
1answer
58 views

How to require a cell input if another cell has a value

I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I ...
3
votes
1answer
166 views

Add/Subtract button Excel VBA

Here is an example of my project in this picture I like collecting, so I am making an inventory sheet in Excel. I want to make a way that I can click a button and it affects the next, or previous ...
1
vote
1answer
62 views

Can the data validation list width be controlled in Excel 2007 and greater?

In Excel 2007, I can add data validation to a cell, and supply a list of allowed values. However, experimentation suggests that the data validation drop-down list will never display at a smaller ...
1
vote
1answer
24 views

How to generate a series of growing values and timestamps for cell that updates automatically?

I have a cell A1 which references a sheet that gets updated by an external source (database). My goal is to record a log that traces the growing value of cell A1 at each different time the data is ...
0
votes
1answer
76 views

VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function. The purpose of the macro is after ...
0
votes
1answer
40 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
519 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
110 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
1k 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
214 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
343 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
165 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
80 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
108 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
75 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
106 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
283 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
126 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
42 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
43 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
43 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
289 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
315 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
414 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
135 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
3k 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
311 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
1k 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
135 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
331 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
90 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
5k 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
520 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
222 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
1k 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
966 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
227 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
917 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
8k 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
643 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 ...