Tagged Questions
3
votes
2answers
23 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
1answer
41 views
How can I update this macro to only copy columns B thru F onto the new sheet? [closed]
I have multiple search strings such as: SearchForString 503, TH00000, XYZ if ColE, ColF and ColC are met I only want to copy columns b,c,d,e & f in that row
How can I update this macro to only ...
0
votes
0answers
34 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 box. ...
-2
votes
0answers
20 views
Copy Sheet and rename based on two columns in a sheet [closed]
I need a macro for the below mentioned problem. Say for example: I have a column A and B in a sheet and in column A say I have 1,2,3,4,5, and in column B say I have A.b.c.d.e against each. Macro ...
0
votes
3answers
72 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 ...
0
votes
0answers
16 views
Get rid of the warning box when save an Excel macro-enabled file? [duplicate]
When save such .xlsm file, I got the below snapshot warning which is quite annoying every time I hit Ctrl-S to save.
How can I get rid of it?
0
votes
0answers
57 views
Need to find four common data columns in different locations in multiple workbooks
I am working from reports generated from different projects. Each report has varying columns but all have the four columns that I need. I would like to be able to boil the sheets down to these four ...
0
votes
1answer
31 views
How to customize Paste Value Excel Short Cut
I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...
0
votes
0answers
50 views
How can I copy/move values below the matching pattern to another column?
I have found this script from this site which moves matching cell values to another column.
Sub MoveData()
Dim myrange, cell As Range
Set myrange = ActiveSheet.Range("B:B", ...
2
votes
2answers
33 views
Excel macro checks if there is formula
I want to make a macro that checks if that cell get its value from a formula. I cann't find anything similar. Any tips??
0
votes
2answers
41 views
How to disable “This workbook contains macros”
This prompt comes up each time I open a file which I trust, is there a way to disable it permanently?
0
votes
2answers
36 views
Need help creating macro in excel rows to columns
I have a data dump in Excel that consists of customer_id data with multiple equipment listed against the same customer.
Data looks like this;
customer_id equipment
1 xx
1 ...
0
votes
1answer
59 views
Split a file with macro in excel
I know there are 2 similar questions.
I have a very large Excel file separated in sections by 3 blanks lines.
I was wondering if there was a way to split the spreadsheet into other every time there is ...
0
votes
1answer
58 views
Sharepoint Document's macros
I'm trying to upload an excel document with a few macros to a 2013 SharePoint, I don't know if I can use the macros via "View in Web Browser" option. I cant get them working, although if I download ...
0
votes
2answers
355 views
Excel macros how to autofill cells?
Hi i am not familiar with VBA code but i know java. I am looking to create a macro that checks if a cell is not blank and autofill the cells in another column but in the same row with the formula ...
-1
votes
1answer
64 views
Data appears different after opening .xls file through a macro
I have extracted a file from a SAP system and saved it as spreadsheet with extension .xls.
I have another excel file which contains a macro to open the former:
Workbooks.Open Filename:= _
...
2
votes
1answer
161 views
How do I refactor VBA code to iterate over worksheets applying a set of cell operations?
This is my code:
'copy cells
Sub start()
'variable for all worksheets in the workbook
Dim sh1 As Worksheet
Dim sh2 As Worksheet
Dim sh3 As Worksheet
Dim sh4 As Worksheet
Dim sh5 As Worksheet
Dim sh6 ...
1
vote
1answer
67 views
How to inspect / view an Excel macro before “enabling macros” for a sheet?
I'm receiving occasionally an xls file that contains a macro which I should use. If I don't have complete trust in the sender, I wish to look at the macro's source in order to verify that it indeed ...
0
votes
1answer
84 views
Cutting and Pasting in Excel Macro
I have approximately 9,000 columns (goes to column MGN) which have 14 rows of data points. I need to get the data in a single column with the format Column B below A, C below B, etc.
Is there any ...
-1
votes
2answers
88 views
How to extract text from within a cell using macro?
I have the following text in a cell that i want to concatenate to another cell.
Pre-Condition:
1. ABC
2. ABC
3. ABC
4. ABC
PQRSTUV
I want to extract the following text:
Pre-Condition:
1. ABC
2. ...
1
vote
1answer
50 views
Excel_macro_pivot table_analyzing data
I have two problems with my data in Excel.
I have this table, so for every day in the year I have got 24 values, that´s 365 columns.
I need to write a macro, that transform the data vertically, ...
0
votes
1answer
57 views
I need to know how to swap the contents of two adjacent cells in Excel based on the content of a third cell
I am trying to swap the content between two cells in Excel based on the content of a third cell. So, I have a column in Excel - say Column C. I want to swap the values of the corresponding cells in ...
0
votes
2answers
253 views
Automatically import a macro to Excel and run it
I have made a module i.e. a .bas file which does the work I want to do in Excel. I have to work with this same module in four different files everyday.
Now I want, let's say, a script which ...
2
votes
2answers
93 views
Format Text Bold based on the value of a cell
I am trying to make the text of cell A1 bold if the value of B1 is "a"?
Is there a formula that can achieve this or do I have to write a macro that can perform this task? Alternatively can I use ...
2
votes
1answer
72 views
Is there any way to programmatically stylize part of a string in a calculated cell in Excel 2010?
Let me explain what I mean.
I have a cell that contains something like this:
="String of text that's moderately long" & YEAR(NOW()) & "."
And I want to know if there's any way that, via ...
0
votes
1answer
278 views
Embedded CheckBox in Excel
I would like to insert Check Boxes in each cell E2:E30 and F2:F30 where one box must be checked in either column E or column F in each row.
0
votes
1answer
151 views
How to create a macro to transfer data from another spreadsheet?
I need a macro that would copy all columns and rows from one workbook to another. I would like that macro to be triggered from a push of a button. When pressed, it would automatically transfer all the ...
0
votes
1answer
172 views
Excel - how to copy all colums in a row based on a condition
I'm new to macros and hope somebody can help
Trying to make a report from a datasheet that meets some conditions.
I need to fetch all the data (cells) in a row e.g. that meet the condition <1 in ...
-3
votes
1answer
111 views
Creating Macro in Excel to copy [closed]
Let's say that I have two workbooks: File X and File Y. (both .csv files)
I am looking to create a Macro that copies from a certain cell in File X to a specific cell in File Y. This would be done ...
1
vote
1answer
54 views
Cleaning up a excel sheet for almost dublicate lines
if i have a workbook filled with data like this example below here
A B C
1 test edge blue
2 test edge red
3 dust daf grey
4 dust daf red
And i want to clean this up ...
0
votes
1answer
100 views
Macro to count the number of text strings in sheet in Excel 2003
I have a worksheet for scoring.
I have a list in the first sheet that will be for data entry starting with a2 and going down the sheet, this is for Player names.
I have a summary sheet named "Place" ...
0
votes
0answers
280 views
How can I create a macro that acts on a relative reference rather than an absolute reference to cell A1?
I have a master rent statement in an Excel 2007 (macro enabled) spreadsheet that shows all tenants in rows with columns formed by the months. Each tenant then has a separate rent statement sheet like ...
0
votes
1answer
187 views
When launching Excel 2010, multiple unwanted macro windows open
When the user launches Excel 2010, it will open five or six windows of excel macros. I know that this is typically removed by accessing View > Macros > Remove the macro but due to the fact that ...
1
vote
1answer
291 views
Excel Macro pattern matching filter
Can anyone help me write this as a VB/excel macro.
I would like to select the following from one data sheet and write to another data sheet.
Select any rows where in column T the field contains the ...
1
vote
1answer
125 views
How to revoke a macro in Excel?
After the execution of a macro in Excel, there's no button to revoke it, unless you close the book and choose not to save it.
Is there a neat and easy way to just revoke it?
2
votes
1answer
634 views
Excel 2010 macro to separate a large data file into workbooks
I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet.
I just need it to separate the files based on a column into a separate ...
0
votes
1answer
257 views
Merging rows in an Excel document with the same email and preserving merged row data
I have an excel sheet of around 50,000 records of something like this:
email product info moreinfo
a@a.com 866 data data1
b@b.com 960 data data1
c@c.com 976 data data1
c@c.com ...
1
vote
1answer
284 views
How to force Excel to treat dates in CSV as text in a macro
I have a macro that lets the user select a CSV file and then manipulates it. However, it treats cells that contain things like 1/2/12 as a date. I need to keep these strings as text, not dates.
I ...
0
votes
1answer
1k 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 ...
2
votes
1answer
480 views
How to split cell in a row with Excel
I am trying to create a macro to split a cell containing two or more line of characters. I would like to keep the others cells of the row.
For example
_____________
| | A |
|Row 1| B |
| ...
2
votes
1answer
126 views
link cell text to file of the same name
i have a workbook in excel and in one column i am putting the names of images.
i want to create a macro/vba code so that when i type in the file name into the column e.g. IMG_1234 it will ...
3
votes
3answers
2k views
How can I split Excel data from 1 column into 8 columns while keeping the data in a specific order?
I need to maintain the order of the data. So to explain I need to move the data from cell
a1 to b1,
a2 to c1,
a3 to d1,
a4 to e1,
a5 to f1,
a6 to g1,
a7 to h1,
a8 to i1,
a9 to B2
a10 to C2
a11 to ...
0
votes
2answers
273 views
Excel macro to extract specific data
I have a spreadsheet with a cell which contains every app on a computer. I want a macro to extract a specific application from the list and delete the rest of the apps and simply display the ...
0
votes
2answers
129 views
How can I speed up my macro in Excel 2003?
I have a macro that copies data from one cell to another and uses a VLOOKUP formula, among other things. My spreadsheet contains nearly 2000 rows.
When I run it in Excel 2003, Excel starts to slow ...
0
votes
2answers
1k views
Excel sheet with macros - just save the data?
I've got an Excel sheet with some macros built in to grab some data from a database. I'd like to save the Excel sheet and send it to someone, whilst still retaining the data. However because it uses ...
0
votes
1answer
984 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 ...
1
vote
1answer
168 views
Create text file named after a cell containing other cell data
I tried using the code below for the Excel program on my `Mac Mini using the OS X Version 10.7.2 and it keeps saying Error due to file name / path: (The Excel file I am creating is going to be a ...
0
votes
2answers
2k views
How to enable Record Macro function in Excel 2010?
After adding the Developers tab in Excel 2010, the Record Macro function became disabled.
How can I enable it again?
0
votes
2answers
649 views
Filter data in sheets from a master sheet
I have a 'master sheet' with lots of furniture data in it, in column A there are the suppliers names. What I would like is to be able to have my master sheet with all the info and then sub sheets ...
0
votes
1answer
862 views
Need an excel macro to produce a formatted text file
I am just learning how to make macros and I found a macro that nearly does what I need it to do, which is output a text file from Excel.
What I need it to do is output this in a .mhd format, which I ...
