0
votes
1answer
16 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 ...
-1
votes
0answers
17 views

comparing two excel documents to match row color of first document

say i have two excell documents, .... one was sorted manually the day before, and then color coated in certian colors based on certian criteria, and the next day a different report comes out that ...
0
votes
2answers
26 views

How to shift unique values down a column to the same value in another column?

My friend has two columns where one has unique values and another column has those same values but also duplicated like shown below Column 1 Column 2 ABC123 ABC123 CDE456 ABC123 EFG789 ...
1
vote
2answers
23 views

String Manupulation in VBA

I have single column that needs to be split to multiple, like Text-to-columns in excel. However there is a small challenge. Conventional delimiter will not work. Consider the string below Original: ...
0
votes
0answers
8 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
1answer
24 views

Store user's personal Excel column filters in a cookie-like file?

I'm developing a reporting app (how exciting!) that puts out HTML, PDF, and Excel reports. In the HTML version I let the user select which columns they care about, and filter out the others. This is ...
0
votes
2answers
29 views

VBA Excel: How to assign .txt file content to a string type variable?

I made a little sub in excel that sends an email according to the parameters you enter: Sub Mail_LSP(mailsubject As String, consignee As String, coalcopy As String, mailbody As String) Dim mlook As ...
0
votes
1answer
26 views

Format text list with corresponding key into spreadsheet

I have a text file with dates arranged as such. name1 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name2 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name3 2011-01-05 (i) 2011-05-05 (i) 2011-06-14 ...
0
votes
1answer
37 views

Hide columns based on content (sum of rows)

I'm trying to hide columns based on the sum of selected rows (i.e., cells) in those columns. For example - if the sum of E9:E12 is 0, then hide column E. Additionally, and probably a little harder - ...
0
votes
1answer
55 views

For loop macro in excel

I am completely new to Excel, but I want to make a macro where I can fill in two columns, and the start and end number of the rows, and it will do this: (A1*B1+A2*B2+A3*B3...)/((SUM of column B)/N)) ...
0
votes
1answer
42 views

Create an Excel Macro to categorize data based on values (by writing data to a cell based on the value in another cell.)

I'm completely at a loss for complex excel tasks, but I'm facing the following situation. I've got a large list of inventory items with various lengths, but I need to convert the exact lengths (as a ...
0
votes
0answers
30 views

VBA Excel: Macro working well, add-in does half of the job

I created a macro that: 1.takes the value in cell "D11" then 2.trims the value acording to some criteria, then 3.opens another workbook ans searches the trimmed value then 4.copies some info to ...
0
votes
0answers
42 views

Automation of solver in Excel by VBA macro code

I'm solving a 3rd degree polynomial equation, e.g., -0.003x3 +0.195x2 -1.087x -180 = 0 in Excel. I can do this by SOLVER of Excel and can find the value of x. The problem is the constant term ...
0
votes
2answers
60 views

Excel concatenation of one column based on values in another

Similar to this: Excel - pivot values in one cell (as comma-separated value) Except it can be a VBA solution, and I do not have duplicates in Column A. Instead, there are blank rows below each value: ...
0
votes
1answer
32 views

Sort with a Macro

I have a spreadsheet with 8 columns of data. (Row 1 contains my headers). I am trying to record a macro that I do not have to edit afterwards. I press record macro, I highlight my data, I go to the ...
1
vote
1answer
104 views

How do I copy hyperlink only (and not text) to another cell? [duplicate]

I have a spreadsheet where column A displays names. There are a few hundred names and each has a different hyperlink (which links to that person's web page). I want to transfer those hyperlinks across ...
0
votes
1answer
51 views

How can I sort data that is organized in 4-row chunks?

I have an Excel document with six columns and 57,000 total rows. Each record comprises four rows, that is, each set of four rows goes together. How can I sort this data by one field while keeping the ...
1
vote
2answers
46 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 ...
0
votes
1answer
99 views

VBA EXCEL: find method not working when looping through each cell in selection

I'm trying create a macro that, after a range selection, will tell me how many 20ft or 40ft containers where found in the sample. The macro basically looks for the string "1x20" or "1x40" and when ...
-1
votes
1answer
41 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
100 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 ...
3
votes
0answers
65 views

How to get rid of macro leftovers in Excel?

Old macro workbook from Microsoft samples gallery left items on the ADD-INS ribbon tab, highlighted by yellow: These cannot be deleted or at least I don't know where to find them – see Customize ...
0
votes
2answers
84 views

VBA Excel 2011 for Mac: Create custom category for user defined function error

I created several functions i.e.: "cal_adval". I would like to add it to a new function category named "Custom Clearance" I read the documentation, and wrote this macro: Sub add_category() ...
1
vote
1answer
136 views

How can I set the primary maximum and minimum Y-values equal to the corresponding secondary Y-values on a graph in Excel?

I was wondering if there was a way I can set the scale on a chart so that the primary maximum and minimum Y-values equal the same values on the secondary Y axis as well? Basically I have a number ...
0
votes
1answer
77 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
55 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 ...
0
votes
1answer
50 views

Clever way to connect multiple images to on-click macro - VAB Excel

I have asked this question before, but admittedly in a terrible way, so I am asking this again. So here I am once more. I am making a program in VBA Excel - or better, combining a certain worksheet ...
0
votes
1answer
73 views

How can I embed a tracking GIF in an Excel document?

I want to add www.sometrack.com/blah.gif to an Excel document. My goal is to embed a trackable element (e.g. a GIF). I want to send a person this document, and if they open it, the pixel opens ...
-2
votes
1answer
98 views

Macros to parse excel data [closed]

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
333 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
26 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
72 views

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

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
36 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
16 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
106 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
1k views

hide/unhide rows based on cell value [duplicate]

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
33 views

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

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
47 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
58 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
32 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
38 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
353 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
35 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
51 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
112 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
47 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
340 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
1answer
278 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
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
2answers
156 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 ...