-2
votes
1answer
21 views

Macros to parse excel data [on hold]

When I am copying the data from putty after queries like ( Select * from tis_zfb where rownum<2; ) the data is getting shrinked, the null values are getting replaced by the values from there right. ...
0
votes
1answer
28 views

Merge Multiple Excel File

I need to merge a few hundred Excel files into in one Excel file. Each Excel file needs to be merged into its own worksheet in the workbook and the worksheet it's merged to needs to be have the name ...
0
votes
1answer
11 views

Identify Image in Excel - VBA

I have an Excel sheet, and I want to create some macros using VBA. Specifically, I want to change an image with a predefined one, every time I press a button or every time I press on an image. ...
-4
votes
1answer
53 views

VBA for “IF formula” with multiple results in a single cell [on hold]

How can I convert this to VBA? Using this formula, it cover 6 rows only and the formula is already too long. My report has 600 rows. =IF(AND('Risk & Issue Log'!$K$2=$D5,'Risk & Issue ...
0
votes
2answers
28 views

How do I make a button to add new fields in Excel?

I have a formula which uses a constant. Every time I copy and paste the cells for a new day, I want the constant to update to the new one. I was thinking I could create a button to copy the fields ...
0
votes
1answer
12 views

Excel leaving formula when selecting another sheet

I am attempting to reference a range in another workbook in a vlookup. I type "=vlookup(a1," and then go to the other workbook to select the range, but alas, I am no longer in the vlookup formula. I ...
0
votes
1answer
38 views

Excel - How can I highlight duplicate cells in near-matching worksheets?

I'm running a March Madness bracket tournament using Excel spreadsheets. I have one sheet where I will input the actual winners. I have an additional sheet per participant that is near-identical, only ...
0
votes
1answer
71 views

hide/unhide rows based on cell value

Based on a cell value = true or false, I conditionally formatted rows to turn black. That means that I need to scroll down to find the set of rows that did not turn black. I would prefer that all my ...
0
votes
0answers
29 views

Is there a way or code that will pull data from Excel and place it in specific order on powerpoint presentation?

I'm going crazy trying to figure this out, there has to be an easier way. I will try to explain as best as possible: I am preparing a powerpoint presentation for a trial, it will contain aprox. ...
0
votes
0answers
25 views

“Filter by Selected Cell's Color” is so slow

I have a row includes like 60-70 thousand lines. 30.000 of them colored. And I'm trying to filter them by "Filter by Selected Cell's Color" but it's so slow. It take forever to filter just 70.000 ...
0
votes
1answer
34 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 ...
-2
votes
2answers
28 views

How to write a macro in exel?

I need to cut the contents of the cell, to write a quotation mark, paste the contents of the cell to write another quotation mark then move to the next cell. Or anything else with the same result.
0
votes
1answer
31 views

Adding two numbers using macros failed to execute

How to add 2 numbers using macros? I tried below but i am not able to execute. Sub auto_open() n1 = InputBox("enter fiest number") n2 = InputBox("Enter 2nd number") ...
0
votes
1answer
57 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 ...
1
vote
2answers
7 views

Workbook doesn't find macro

I created a macro in a workbook which is being used by several persons on their own computers. For some of them, it seems to work fine, but for other a message appears that it can't find the macro on ...
0
votes
1answer
31 views

How can I create an Excel Menubar Button to run a Macro?

Background: I created a macro for a friend that will create a pivot table from a large worksheet of data. The data will always have the same number of columns with the same column headers; the number ...
0
votes
1answer
39 views

How to merge rows with same Name merging data of each ?related column

I need to merge rows with same Name preserving data of each column. For example, if we have two rows with the name "Mr Bean" on the first column "Name" then merge data of each column related to rows ...
1
vote
1answer
31 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 ...
4
votes
1answer
106 views

Using English macros in French version Excel

I am currently in France and am using a computer on which all Office programs are in French. I need to use a Macro which has been written in English VBA, but it fails. I assume the issue a language ...
0
votes
0answers
138 views

Macro to Import CSV files into Excel

I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data ...
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
2answers
95 views

VBA macro to remove everything before and after <div> tag [duplicate]

I'm creating a report that has a column with lots of cells that have HTML tags in almost every box. I'm trying to create a VBA macro that will remove some HTML tags from this column. So in one ...
0
votes
0answers
77 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 ...
1
vote
1answer
38 views

How to cross data from 2 excel sheets

I'm doing a small internship at a local library. My mentor requested my help to a do lenghty job, but it has to be done over the week.. So, this is what he requested me: to look up in 2 different ...
-2
votes
1answer
152 views

Excel 97-2003 Macro does not work in Excel 2013

I have an Excel file that was done in Excel 97-2003. It contains a macro. The macro runs fine in Excel 2010 but have now had to convert to Excel 2013 and the macro does not work. I am only a basic ...
1
vote
1answer
44 views

How to create multiple rows combining data sets

I have three tables and i need an out put which has data from two tables, i would like to create the same using macro. Table A A B C D Table B Apple Orange Pears Table C Americas Asia Europe ...
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 ...
2
votes
0answers
160 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
226 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
2answers
445 views

Checkbox in dropdown list

I have a table in excel where I can select multiple items from a dropdown list in one cell. Now, using my macro I have to pick all of the options separately, and they are added to a cell one by one. ...
0
votes
0answers
150 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, ...
0
votes
0answers
26 views

Microsoft Excel, setting variable reference

I am converting a macro that used a set date range to only extract the products needed within that date range. However, as certain products have different availabilities I would like to extract all ...
1
vote
0answers
60 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 ...
0
votes
1answer
62 views

How to format time with decimal places with excel vba?

I'm trying to write a macro that takes a time value in seconds (decimal) and converts it to mm:ss.00 format (two decimal places.) The closest I've come is this: Application.Text((1.23 / 86400), ...
0
votes
0answers
67 views

Excel Combo box to filter a table column

I have a table that I want to filter a column of 'team names' (D10 is the column header) using a combo box (which has a list of the 10 team names from another sheet). So, when I select a different ...
1
vote
2answers
64 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 ...
0
votes
0answers
141 views

Using VBA to sort cells to match the values in an adjacent column

What I would like to do is write a macro that sorts the values in the range B3:D9 on the left side of the linked image to produce the intended result (shown on the right side). For every value in ...
1
vote
0answers
86 views

Add-in vs sharing macro file in Excel VBA [closed]

I am writing a Macro that I want my team members to have access to on their machines so we can use it to upload some monthly data stored on some space accessible on the Network. This is my first macro ...
0
votes
1answer
214 views

excel macro to look up data from a database and copy it to another excel file or sheet

I have an excel file which looks up and calculates data for a given date. It works as follows: You enter the date in a specific cell (input) and in the same sheet the required data appears (20 cells). ...
0
votes
0answers
32 views

Summarizing data in Excel

I'm working on rolling-up a series of charts. I'd like an easy way to summarize by category. The original looks like the sample below but by week for the entire year. I want to know all of the AD ...
-1
votes
1answer
112 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() ...
0
votes
0answers
49 views

Macro to manage sport ranking and calendar?

I need to write a macro (or a different easy way) to manage ranking and calendar for curling tournament. The event will follow the Shenkel system first match determined by general draw after that ...
2
votes
1answer
363 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
901 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
485 views

Importing Text in Excel 2010 - Overwrite previous imports

I created a macro, using the recorder, to add a specific .txt file in my Excel file, using a specific shortcut key, in a specific area of the open excel file. However, I've got this problem: when I ...
0
votes
1answer
487 views

Excel 2010 VBA - Trigger macro with ONE click on specific cell

Would you mind pointing a way to start a macro in Excel 2010 by clicking only once on a specified cell? I had seen a solution somewhere, but now I can't trace it back.
0
votes
0answers
139 views

How to extract date-time from a string and format it to YYYY-MM-DD 00:00:00 & add back to the string in a excel column?

How to extract date-time from a string and format it to YYYY-MM-DD 00:00:00 & add back to the string in a excel column? The column can vary.So,it should allow to work on any column selection. ...
0
votes
2answers
106 views

Excel VBA Right Function Error

I'm trying to automatically update the date range on the top of my report in Excel based on the date range from data I download from a text database. In the below listed macro I get a Run-time error ...
-1
votes
2answers
346 views

Script/ Macro in Excel, by clicking on a cell

There's something I want to do in Excel 2010. Specifically, I want to be able to make the open sheet load data from a text file, by clicking -important- on a cell of the current open worksheet. So ...
-1
votes
1answer
51 views

Is there a macro to validate URLs to check if it page loads or not in excel?

Is there a macro to validate URLs to check if it page loads or not in excel ? I have a list of url in excel.