Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with excel
Search options questions only
not deleted
user 79537
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
9
votes
2
answers
2k
views
Extracting Country Names from Cell Values
This fairly clunky looking VBA script successfully pulls names of countries from an Array, but could it be made shorter?
Mass of text from Column C onward in each row may contain the names of countri …
- 423
5
votes
1
answer
96
views
Rearrange data without using Cut and Insert
I'm fairly new to VBA, and this was basically a brute-force solution to a problem I was encountering. I wanted to take data that appeared in two columns, and pull it together into one.
The current c …
- 423
4
votes
2
answers
62
views
Re-arranging data on a worksheet based on contents of Column A
The following Macro sorts through a worksheet, copying and removing lines based on what appears in column A. If ("A" & i) is not a number, it triggers and moves the data to the appropriate place. The …
- 423
5
votes
1
answer
1k
views
Mailmerge from Excel to premade template in Word
I've written the following code to take data from the Excel file "Data" and use it for a mailmerge in a prepare Word template named "Template." …
- 423
2
votes
2
answers
92
views
Re-arranging an matrix of numbers to a numeric list
If I have an array of numbers like this:
1 3 4 6 7
1 2
2 4 5 9
5 7
1 2 3 5
Is there a quick way to take all of the unique numbers and arrange them into a single column, like this?
1
…
- 423
3
votes
2
answers
67
views
Re-arranging a list into columns
In short, what this script aims to do is take the following data:
1
Alpha
Beta
Delta
2
Beta
Echo
Foxtrot
Kilo
3
Alpha
Kilo
4
Beta
Echo
Kilo
Zulu
And re-arrange like this:
1 2 3 …
- 423
3
votes
2
answers
174
views
Copying lists into columns of a table
Edit: I found a potential solution. Changing all of the Dim as Long to Dim as Integer allows the scripts to run smoother. However, there is a potential that the number of rows in some instances will e …
- 423