0
votes
1answer
18 views

Excel 2010 Formula: Finding a dynamic column based on string value, then count # of “0's” within that column

I have tried looking at many different potential avenues at solving this; INDEX, MATCH, DCOUNT, HLOOKUP with INDEX & MATCH, COUNTIF with INDEX & MATCH. What I'm looking for is a way to set the ...
0
votes
1answer
22 views

How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2 And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 ...
1
vote
1answer
24 views

Transferring custom excel ribbons in local computer to other computers in Excel 2010

I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons. I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to ...
0
votes
1answer
49 views

Merging multiple excel files in to one file

This is my macro for merging all the files in one directory to one excel sheet. I am unable to find why its not working as per expectation. I have thousand rows in each file. It copies 1000 rows from ...
2
votes
1answer
47 views

Excel Help: How to scan a row and return the value of the first cell in that column

I have a matrix of numbers and the matrix has column header -- say like this: a b c d e f 0 0 0 1 0 0 0 0 1 0 0 0 What I want to do is to search for each row for the element 1 and return its ...
-1
votes
1answer
162 views

How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach. Basically as i stated in the title i need to write a macro that will copy the selected row or ...
0
votes
0answers
14 views

Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010. It's a excel 79 to 2003 xls file. We checked trust centre on 8.1 but no joy, ...
0
votes
0answers
29 views

Can I write a Macro to export data from Web?

I need to write a macro that can import data from the web (salesforce.com). Is it possible to pull data from the web through a macro? The data I will pull from salesforce.com, is a monthly task. Can a ...
0
votes
1answer
62 views

Months and Date keep being switched around when running VBA

I have a column on my sheet, Column F which is full of dates. Now I need these dates to be in this format "dd,mm,yyyy" but sometimes they are in text form, us/armenian format in the original data. Why ...
1
vote
2answers
50 views

Copy selected items in Excel filter

I have been strugling for past several day trying to resolve this issue. Here is what I have and what's needed: I've got about 20 Excel sheets that contain massive data (around 50K rows/sheet) that ...
-1
votes
1answer
48 views

How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ? So, this... A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB ...should split as below, B1 ...
0
votes
2answers
162 views

Split single column data into multiple columns based on leap year in Excel 2013

I have about 100 files of MS Excel which consist of weather data. I need the data on yearly basis but the file has a single column with data of about 140 years and manually copy-paste is very time ...
0
votes
1answer
98 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
3answers
63 views

Reformat data through macro excel 2010?

I am trying to create a macro that allows me to change the data I received from a client into data I can import into a system. The data I receive is in the format: How Can I do this through VBA ...
1
vote
1answer
41 views

Searching the string in a text sitting on 1 coulmn

I'm very new into VBA coding, I would like to have some assistance as I have been trying for two days, I have got data fixed in column A, I would like to search for a string in that column, eg ...
0
votes
1answer
58 views

Update macro values when cell value changes

I have a checkbox control with a macro that takes value from cell 6 columns over and inserts it in either the 8th or 9th column over depending on whether the checkbox is checked or unchecked. This is ...
0
votes
2answers
19 views

How to change the Range for the Location of Workbook and Sheet in macro?

I have Found a macro on this site: How can I compare two columns in Excel to highlight words that don't match? My question is how can i change the link or the range of the column to different ...
0
votes
1answer
66 views

How to combine several excel workbooks into a single book

I have several, multi-sheet workbooks which I would like to combine so that I can search them all simultaneously. So, the merged workbook will contain tabs 1,2,3, of the first workbook, then tabs ...
0
votes
0answers
73 views

Reformat a text file using a macro in Excel

I need to reformat a report I receive every month as a text file so I can perform spend analysis on the data in Excel. The report was in a statement format before converted to a text file because the ...
1
vote
1answer
54 views

How can I force Excel to recalculate after a UDF macro error?

I created a bug in a user-defined function that is called from a large number of cells on many tables in an Excel workbook (not the way I would design it, I just "inherited" it). But now, I can't ...
2
votes
0answers
280 views

Splitting an excel 2010 spreadsheet into multiple workbook files based on column value

I find and clean a lot of contact data, sorted by country, which I am currently using excel to manage. Mainly because it is easier to clean and manipulate the data I find this way, and I can easily ...
0
votes
0answers
304 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 ...
0
votes
0answers
211 views

VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below). Please note that: Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table' The number of columns, ...
1
vote
0answers
88 views

Is there a macro to filter table by some list elements?

I have a table with entries based on a list and I used a macro I found somewhere to be able to add/remove multiple elements from the list to one cell, let me show you an example: TEST TABLE test1 ...
1
vote
2answers
125 views

VBA macro in excel 2010 32 Bit mode

I have a excel sheet which saved using Excel 2010 64 Bit. It has a code as follows Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 1 And Target.Column = 17 Then Dim iRet As ...
1
vote
0answers
28 views

VBA to sequentially number rows in column [duplicate]

I want to number sequentially all cells on sheet4 starting at A2 (starts at 0) for 26000 cells in the A column I have been trying the get the below code to work but need help. Sheet4.Range("A2") = 0 ...
0
votes
1answer
3k views

Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to ...
-1
votes
1answer
134 views

Excel 2010 VBA on-start macro execution - Error

I have been trying to create a macro to be executed every time I open the document. I tried to use the Open event, but it does not seem to be working. The code is below: Private Sub Workbook_Open() ...
2
votes
1answer
762 views

VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses. I need a Macro/VBA that moves any word in red from column A into column C as a list. However if the same word is ...
2
votes
2answers
2k views

How can I compare two columns in Excel to highlight words that don't match?

(I'm using Microsoft excel 2010) OK, lets say I have a list of phrases in both column A and column B (see screen shot below) What I would like to happen whether it be with a macro, VBA or formula ...
1
vote
1answer
166 views

Pull Data from Excel Worksheet to Another Based on Defined Values

I have two excel worksheets which have data cells. I want that if a cell in column J equals a certain value, let's saying "Negotiating", then it automatically pulls that row to a new worksheet. The ...
0
votes
0answers
98 views

Excel - How do I write a formula or a macro to copy cells to a JPG file properties?

I have over 1000 jpg files and one excel file with all the properties(metadata) for them - title, subject and tags. The excel looks like this: Number ......Title ....... ...... Subject .. ...
0
votes
1answer
388 views

Find and Replace VBA/Macro in Excel 2010

Another Excel VBA question. I'm using Excel 2010 I want to create a Macro that will remove the following 3 symbols in any cell for a selected range: [ ] " For example; If I select a range of ...
0
votes
1answer
556 views

VBA to insert a carriage return after existing text and paste more text

I'm adding "Measure_1" within certain cells. This requires me to double click in the cell, go to the end of the existing text, insert a carriage return (alt+ent), and then paste in MEASURE_1. ...
0
votes
2answers
69 views

Microsoft Excel Macro

I have an excel sheet that contains names (1st row), job titles (2nd row), company/institution (3rd row), and addresses(4th row) in one big column. I am trying to separate them into four different ...
1
vote
2answers
2k views

How to permanently add macros to Excel as part of the program? [duplicate]

I have a macro where I'm not sure when I will need to use it. I need them built into Excel to be able use them at every start of the program – like you would install some add-on (e.g. Kutools). ...
0
votes
1answer
1k views

Running a macro in current sheet and in all sheets after current one

I have a excel file, that has 12 sheets, each corresponding to a month. I have three macros that execute in a sheet they are run in. Is is possible to do it in a way, that if I run macro in sheet ...
0
votes
0answers
420 views

Create a Macro that searches, copies and Exports from two workbooks and imports into 1 master workbook

I am new to creating macros. I have tried searching for existing macros to help with my current request; however I have not found a helpful one. Please let me know if you can assist. Contents ...
1
vote
1answer
214 views

Deleting entire row using macro in excel

I have and excel spreadsheet and I need to make a button that deletes the entire row in which the button is located. Lets say I have a button on cell G7. When I press it, I want the entirety of row 7 ...
0
votes
1answer
1k views

ActiveSheet.ChartObjects(“chart”) always returns Nothing?

I'm querying for a chart in the worksheet and I can see it's there but everytime I execute the following piece of code it evaluates to 'Nothing'. Why is that? Sub DeleteGraph() Dim graph As ...
0
votes
1answer
345 views

Sequential Number in Excel within Specified Range

I have been looking for the macro since last week but with no luck till yet. Would appreicate the efforts if you please get me out of the problem that i am facing, I have created excel template (used ...
0
votes
1answer
79 views

exec 2010 VBA related error: “can't find project…”

Have made a (refinery process industry-)model under Excel 2010 with many macro's (based on a Excel 2003 sheet) Had some difficulties getting it to run wih the right addins but OK now. However, other ...
0
votes
2answers
2k views

Creating a command to clear clipboard in Excel 2010

I would like to make a command that will clear (reset) Clipboard while I am using Excel 2010. I would prefer this as a button in Excel, but it can be a shortcut on the desktop as well. Is there any ...
1
vote
1answer
283 views

Macro to import CSV file into Excel 2010 without losing leading zeroes or cell formatting

We have a UI based application that exports data out of a form into a CSV file. The data entered may have leading zeroes in some numeric fields and/or text with line feeds in other fields. ...
1
vote
1answer
594 views

How can I easily toggle display of page breaks for all worksheets in an Excel 2010 workbook?

Excel 2010 only allows turning page breaks off or on for one worksheet at a time via File → Options → Advanced → "Display options for this Worksheet": I previously came up with a VBA ...
0
votes
1answer
1k views

Excel VBA Macro to Create Custom Lists From a Selection

Hi I was wondering if anyone could help me create a macro that will add a selection to excels custom List. Typically to do this I select a a series of rows in one column, then I got to file, options, ...
0
votes
0answers
31 views

I need help writing a macro that will check a condition, and then paste a value into a different cell [duplicate]

I want to have a macro that will check to see if a specific value exists in a data range, and if that value does exist in that data range, then I want to past a line of text in a different cell. Could ...
1
vote
1answer
303 views

Why don't I see this code as a macro in Excel?

I tried using a bit of code provided from this previous Super User Answer: Sub OpenCsvAsText(ByVal strFilepath As String) Dim intFileNo As Integer Dim iCol As Long Dim nCol As Long ...
0
votes
2answers
79 views

Need simple macro for “match” formula

Are column B cells hidden somewhere anywhere in column C? Give results in column A. (true/false or yes/no) I'm unable to post the simple Excel image I've created as I'm a guest, but it shows simply ...
0
votes
0answers
126 views

Why does my Excel macro fail when run from a hotkey and work when run from the macros ribbon?

I am really confused by what is going on with a macro I created to parse out space delimited files. The macro runs successfully as long as I select the macros ribbon and the macro from the dialog ...