I'm trying to import several .log files into Excel using the Data tab - I can do that but I have several to import (about 200) and I'd like to do this quickly - how can I do it please?
The .log filenames are 9-digit numbers that I also have a list of in my workbook if that helps.
Ideally I would like to import these logs side-by-side on one worksheet with the name of the log file appearing above them thus:
803238372 (this is the filename)
Log In 29/03/2010 08:21:21 BTG358057
Log In 30/03/2010 08:25:23 BTG358057
Log In 31/03/2010 08:29:48 BTG358057
Log In 01/04/2010 08:23:34 BTG358057
Log In 02/04/2010 12:13:05 BTG358057
Log In 06/04/2010 08:28:57 BTG358057
Log In 12/04/2010 08:32:32 BTG358057 (this is the imported data)
I've tried a few of the macros other people have suggested but no joy - I need the data to update as it will be added to each day.
Is there a very quick way to edit names in excel so that you don't need to individual change each one?
Thank you.
Good morning all,
I have a list of over 600 unique names and need to create a folder for each of them. I'm sure this can be easily done in Excel but I'm struggling (perhaps with my terminology?). I've found a few discussions in the message board but non that seem to do what i need...
Any help would be greatly appreciated.
Kind regards,
Matt
Let's say I have a range of numbers in D1:F4 and a range of names (tags) in A1:A4. In the range B1:C4 there are other things.
I would like to automatically assign the names in A1:A4 to the range D1:F4 in order have a defined range name for each array in the rows 1->4. Using "INSERT/NAMES/CREATE" doesn't work beacause it includes in the range also collumns B & C whereas I need ranges to start from collumn D
Is there a way to do this automatically (of course I have to do it to 100 rows at least otherwise I wouldn't bother)
Thanks in advance for any support and sorry for my english
Paolo
Italy
Hi:
I searched the site but came up empty. Does any one have code that creates multiple file directories based on the names in a range of selected cells?
Thanks for your help
Hello,
I've tried to search the forum to solve this issue but I can't find a close enough example.
I have a complex financial model which I'm trying to automate using VBA. The next step in my process is to create a macro which will assign a name to each record of a database based on the value in the last column.
The first row of my spreadsheet contains the column headings. There can be any number of records (from 1 upwards) which start on the second row.
For each record (a row in the database) I want the macro to name the range from Column B to Column IN i.e. for the first record the name would refer to (B2:IN2).
The name to be used is found in the last column of the database (Column IO). For example, the first record would have the name Prop1Rent, the second Prop2Rent, etc.
I only want the macro to create names for the rows with data - I don't want to name the blank rows.
Any help would be greatly appreciated!
Matt Jessee (glamlife)
I have single-row item entries on the front sheet, with each one named as a
separate range. Each item will then be tracked on a separate sheet, with
values and such showing up on the front sheet. I'd like to use a Form to
set an action and quantity for the individual item.
Is it possible to open a UserForm that will list all the ranges - whether 2
or 20 - as check or option boxes, and for each range give text boxes to
allow input?
Ed
Is it possible to automatically add links to each entry in a given column?
i.e. In column A, I need each word/set of words to be hyperlinked without me having to manually do it myself.
Something like this:
Column A
Smith, Joe------> http://www.mysite.com/redirect.cgi?redirect=Smith_Joe
Thomas, Henry --> http://www.mysite.com/redirect.cgi?r...t=Thomas_Henry
(I also need the underscore between the two names in the hyperlinks "_".)
Is this possible?
Thank you
Hello,
I have a list of 10 Contractors in worksheet1 Column A
In worksheet2 I have a bunch of rows of data of hours recorded by Contractors and Employees for a particular project. The name of the employee that recorded the hour is in Column B.
In that same worksheet, I would like to create a unique list of only the contractors that contributed to that particular project (may be only 1-3 of the 10).
Does anyone know of a formula that will allow me to do this? I found a formula that will allow me to create a unique list, but does not include the criteria that they be a contractor. Also, the formula I found would force me to manually enter the number of rows of data that I have (e.g., $B$2:$B$10) The formula I found is this: =IF(ISNA(MATCH(0,COUNTIF($C$2:$C2,$B$2:$B$10),0)),"",INDEX($B$2:$B$10,MATCH(0,COUNTIF($C$2:$C2,$B$2:$B$10),0)))
Any idea how I might do this with a formula?
If there is not a way to do this with a formula, does anyone have the VBA code that would make this work? I have only a very little experience with using VBA code in excel, but may be able to figure it out.
Thank you so much for your help,
-jbetzold
