0
votes
0answers
9 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, ...
1
vote
1answer
57 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 ...
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
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
1answer
79 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
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
355 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
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 ...
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 ...
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
27 views

How to use the Integer i.e. currentregion's row from the macro in a cell's formula

How do I use the row from the current cell, in another Cell's Formula on another sheet? I created this Macro, but don't know how to use the Integer from the macro in a cell's formula. In a macro I ...
0
votes
0answers
66 views

Saving excel as csv without messing the formula

I have an Excel workbook with 55 sheets. I would like to save the sheets as csv files (file name is the name of the excel sheet). When I run the macro, the files are created as desired but the macro ...
1
vote
1answer
322 views

excel macro with column criteria to copy two rows in one sheet to another

I need a macro that searches for a string in a column; on finding that string it copies the row in which that string is found as well as the row above that. For example: Search for "boy" in column ...
0
votes
0answers
136 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 ...
1
vote
0answers
148 views

Microsoft Excel Copy one row to another worksheet if cell contains specific data

I have never written a macro in excel before. I am trying to organize my PTAs spirit wear orders for ease of placing the order. I have entered all orders into a master worksheet titled "spirit wear". ...
0
votes
0answers
396 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 ...
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 ...
3
votes
2answers
458 views

Get first and last value from range in a spreadsheet using other column's data for filter criteria

I have data in my spreadsheet in a worksheet like this: Where the data goes in this format [ID] | [Date] | [Hour] | And I have another worksheet where I want the data to be like this: Where I ...
0
votes
3answers
471 views

How do I separate three different phone numbers concatenated in one cell into three new rows?

I am doing work for a client and need to know how to separate these phone numbers. I have 0121 396 0501 / 0121 123 434* / 0797 978 8265 in one cell and I want to end up with the same row ...
-1
votes
1answer
45 views

How to merge with macro? [closed]

From input of this kind: CUSTOMERCODE DATE QTY 890550 16/04/2013 10 890550 16/04/2013 20 890550 17/04/2013 20 890551 18/04/2013 30 890551 18/04/2013 30 ...
0
votes
1answer
944 views

Excel Macro to extract header, and rows then email

I am attempting to find an Excel macro that would get the headers from a table, and then copy certain rows into an email. For example State | Store | Points Store1 | VIC | 3201 Store2 | ...
0
votes
1answer
3k views

Copy/move values matching a pattern to another column

I have a worksheet where we need to move all the values matching a pattern to different columns. For example, we have a B column with values that are one or more letters followed by one or more ...
0
votes
1answer
145 views

Is it possible to automate tasks within a Macro in Excel

I am relevantly new to Macro therefore would like to know if the following is possible; See what it is, I've created a Macro that compares the data on sheet1 to the data on sheet2 and reports the ...
2
votes
2answers
1k views

In Excel 2007 where do you store macros that you want to use on all sheets that you open?

It looks like you can store it in a file called PERSONAL.XLSB and that will create "Global" (for all worksheets) macros. This file is of course stored in your user profile ...
2
votes
1answer
661 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 ...
0
votes
1answer
3k views

Auto create folders using Excel field entries

I need to generate folders containing certain Excel field entries: Additionally, I need to append a date to the folder name based on that entry So If I have the above Excel table, I'd need the ...
4
votes
9answers
28k 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 ...
2
votes
1answer
1k views

How to automatically create Excel graphs from Access data [closed]

I have some data in Access from which I have to create Excel graphs every month (data would also be updated every month). So it's creating the same charts with different data every month. Is there a ...
0
votes
1answer
228 views

Auto date calculator in excel based on different conditions

I have an excel sheet with an auto date calculator function linked to each cells. I want this function to work based on different condition. For eg: (lets say there are two conditions A and B)for ...
1
vote
1answer
4k views

Run macro upon opening Excel 2007

I need help setting up macro that runs each time I load Excel 2007. I have tried following a few walkthroughs on the web but they end up not autolaunching the macro.
0
votes
1answer
3k views

Excel cannot open the file “filename.xlsm” because the file format or file extension is not valid?

In Excel 2007, I get this error when I try to run a script a friend posted to the web. I have heard of no one else having trouble. Any ideas what might be going on here?
0
votes
3answers
9k views

Excel VBA Macro Sub or Function not defined

I used the macro recorder to generate a macro in Excel 2007. When I try to the run the macro, it tells me: When I click Ok the definition of the macro gets highlighted. I'm really confused ...
1
vote
1answer
548 views

Convert <x ug/kg to <x mg/kg MS Excel 2007 macro

I have to interpret data for scientific reports. We report the data all in the same units, however, the lab sends the data in different units. I would like to know how to make a macro that you can ...
0
votes
3answers
3k views

Using dynamic links to external workbooks in Excel

I have a master workbook that needs to pull data from a specific dated subfolder. The date is specified by the user prior to macros being run. The master workbook acts only as a presentation layer, ...
2
votes
3answers
8k views

Excel workbook protection: how can I stop users tampering with a workbook?

I have a workbook with a lot of sheets, macro's and calculations going on. I now need to send this sheet out (not forseen before yesterday). How do I lock it down so that users: are unable to ...
-1
votes
3answers
294 views

Macros Excel 2007 - extracting data

Im trying to extract certain data from a cell and trying to put it somewhere else within the same cell. Any suggestions? EDIT I have several text strings in ONE cell (a date, a part number and a ...
1
vote
1answer
356 views

Excel: Why use an XLA and not just a blank XLS?

Someone has put lots of Macros in blank XLS documents, and now someone has aked me to put them into an XLA document. Why and for what purpose? The Macro's loop through opening workbooks and ...
0
votes
1answer
689 views

Excel Macro: compare separate workbook lists and LINK to the data in a corresponding column?

1. How can I compare two matching lists from separate workbooks? And then retrieve the data from the same row but another column - (Index&Match maybe be appropriate for this). But how does this look ...
0
votes
3answers
2k views

Excel VBA/Macro: how can I delete rows and remove dots & dashes?

I've recently been handed an Excel file to format - 100's of lines. The image below shows you the state of it. This could be a really long exercise if I work through it manually, so I wondered if a ...
8
votes
6answers
32k views

How to turn hundreds of text URLs in Excel into clickable hyperlinks?

How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser? I pasted 100 urls and each went into its own cell. When I double-click in ...
0
votes
2answers
1k views

Backing up Excel Files to a different Directory

In Excel 2007 in the Save As box there is an option to 'Create a Backup' which simply backs up the file whenever it is saved. Unfortunately it backs up the file to the same directory as the original. ...