2
votes
1answer
35 views

Move every 3 rows into a column in Excel

Please I need your help. I need to move every 3 rows into a new column. Let's suppose I have this: Ambassade de France S.E. M. Patrice PAOLI 01-420000-420150 Ambassade de France Mme. Jamilé Anan ...
-2
votes
1answer
78 views

Macros to parse excel data [closed]

When I am copying the data from putty after queries like ( Select * from tis_zfb where rownum<2; ) the data is getting shrinked, the null values are getting replaced by the values from there right. ...
1
vote
1answer
61 views

Conversion of delimited .Txt file into Excel file [duplicate]

I have a delimited .Txt file containing several fields (separated by spaces) and I want to know how can I copy the entire thing into the MS Excel using any script (JS/VB/DOS Command) which can be ...
1
vote
1answer
103 views

Need a Excel script to identify email addresses that contain a different variation of the first name of the contact

I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc. We are basically trying to ...
2
votes
1answer
302 views

What do the different ping statuses returned by VBS scripts mean?

I have a VBS Script that executes this code strQuery = "SELECT * FROM Win32_PingStatus WHERE Address = '" & Cell & "'" Cell - is the Excel cell with the hostname Some of my results are ...
0
votes
1answer
381 views

Excel - Change font color of a row on double click

I'm trying to change the font color of the row in which the cell is located when I double click it from black to grey, and the opposite when it's already grey. Here is the code I'm trying: Private ...
1
vote
1answer
5k views

VBScript in Windows 7 64bit Scheduled Task - Works with only run when logged in

So basically I have this VBScript that opens up an Excel 2010 instance, run a macro in it and close the spreadsheet. I am calling it using Scheduled Task to automate it. It ran beautifully when I was ...
0
votes
1answer
256 views

Using Excel to capture URL redirects

In Excel is it possible to have a list of URLs in column A and have a column B auto-populate with the URL of the page you get to if you click the link in Column A. (I would like to audit all the ...
1
vote
1answer
567 views

Excel VB Convert sheet text to unicode chars

I need to enter a function in an excel sheet that converts all cells values, that are texts, to it Unicode values. For example I want ü to be &#252; and so on. How can I achieve this, is it ...
1
vote
1answer
178 views

Creating Custom Sortable datatypes in excel

I want to define a custom data type in excel 2007, a date range. Basically, it's an array of dates or smaller date ranges like: "{ 01-26-1991 , 01-01-2004 to 12-31-2004 , 12-13-2017 }" which ...
0
votes
1answer
2k views

Excel / VBscript: Need to sort columns with a header

I have a vbsctipt that opens an Excel(2007) document copies the used range from two sheets (minus the header on sheet 2) puts it all on 3rd sheet. I then need to sort that data using the header. I ...
0
votes
1answer
3k views

How to lookup an IP address in an Excel spreadsheet?

I'm working with a decent sized spreadsheet of domains and server names. Another user of the spreadsheet needs the IP address for each of the DNS entries on the worksheet. Instead of manually adding ...