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
63 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
57 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
78 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
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 ...
0
votes
0answers
233 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
34 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
25 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
52 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
306 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
113 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
141 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
310 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
2k 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
267 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
320 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
767 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
2k 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
136 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
593 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
2k 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 ...
3
votes
7answers
19k 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
213 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
8k 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
524 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
7k 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
291 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
335 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
660 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 ...
7
votes
6answers
29k 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. ...