Tagged Questions
1
vote
2answers
19 views
Excel VBA code modification so only alert me once for same item
I manage a contract log that list out all of my company's contracts with the effective and expiring date.
I've written VBA code that alerts me whenever any one of the contracts is about to expire; a ...
0
votes
0answers
19 views
Want to create a macro to perform vlookup in excel
I have a spreadsheet that I need to copy data into matching the product code. I know that I can use Vlookup to do that, but I wasn't use if there is a macro to do that? I have never created a macro ...
1
vote
1answer
23 views
subtotaling on live data macro
I have created a data table through Sharperlight reporting thats generates its results into excel as shown below:-
What I want to do is develop a macro that will subtotal all categories for the ...
0
votes
1answer
54 views
Grouping Similar Cells in Excel
I have an excel sheet that has 7000+ records. It has two columns- Number and Title. The rows under the 'title' column contains strings and some of the strings are quite similar. For instance:
Need ...
0
votes
1answer
24 views
Locating first empty cell in a column and ask user to input
I have a big excel file with different dates on Column B (it starts at row 7 and jump to the row 9.. e.g June6th - B7, June 7th - B9, June 8th - B11).
I want to have a macro that locate the first ...
-3
votes
2answers
47 views
Excel & VBA: Copy rows into a new sheet based on cell value
I'm a total newbie in Excel and VBA.
I have a sheet like this:
A B C D
someinfo someinfo someinfo OK
someinfo someinfo someinfo OK
someinfo someinfo someinfo ERROR
someinfo ...
2
votes
3answers
27 views
loading excel files takes forever [closed]
I use huge excel worksheets and they take forever to load because of cell calculations using macros and other formulas (over 5 minutes even if I have a good computer) . I was wondering if there was a ...
1
vote
0answers
20 views
How can I create a macro that find, select and cut columns, and paste them in another worksheet?
Another day, another problem. I think it is easy to make this thing work, but I just don't know how to go further now.
The issue:
On work we get excel sheets from our customers. In this sheet, they ...
0
votes
0answers
9 views
Enble Highlight in Excel using Macro
I have the list of values in each columns in an excel. Each value in each column are linked by an arrow to another value in another column. To provide a higher visiblity, I would like to highlight the ...
1
vote
1answer
35 views
Excel VBA / Macro - TextToColumns for multiple columns?
Is there way to find cell that contains "Date" and run the TextToColumns macro?
instead of referencing column "H" or "J" and/or so on...
Ultimately I am trying to change about 5 columns that contains ...
0
votes
2answers
74 views
Excel - basic copy-paste between sheets macro
I need to do a basic merge of data from 2 sheets where the first part (username) changes, but the second part is say, a preset list of 120 items. ie, combine:
sheet1:USERLIST
albert
benny
cedric
...
1
vote
1answer
9k views
Macro to copy data from one sheet to another, only if not already present
I am struggling with this macro. I have two sheets; One with a large set of data that is updated by a macro with respect to multiple dates.
I want to copy the data from that sheet ("rawdata1") to ...
2
votes
2answers
1k views
Easy VBA Macro to list all worksheets generates error: Type Mismatch
I'm making a ExcelComparer but I bump into a probably obvious error, I clearly missed something.
I run a vba macro in Excel 2007
The exact error I get is "Run-time Error 13: Type Mismatch"
This ...
6
votes
3answers
19k views
How to loop rows with Excel VBA macro?
I am new to VBA, but pretty good with PHP. That being said, I'm struggling with VBA loops...
I have this sheet with 40 rows called "SH1":
SH1
A B C D E
1 2 One 1.0a ...
20
votes
10answers
2k views
What are common anti-patterns when using VBA
I have being coding a lot in VBA lately (maintenance and new code), specifically with regards to Excel automation etc. = macros.
Typically most of this has revolved around copy/paste, send some ...
