|
Try-before-you-buy version?
Hi folks
I have produced a complex spreadsheet (medical application) that is now
available for sale at a modest price. It contains some VBA, but not much. I
am not an expert, but have made extensive use of Excel's built-in functions
for curve fitting, graph ploting etc. A colleague in another (UK) hospital
has asked about an 'evaluation version'. Is there a standard way of
producing a spre...
|
9 |
02.03.2007 00:52:48 |
|
|
Inserting lines according to number of days, adjusting date
Hello
I am using Excel 2003.
I have a table showing meetings. This includes StartDate, EndDate,
Information (about the meeting) and Room. In most cases, the
StartDate=EndDate.
However, for those meetings that take more than one day, I need to have an
entry for each day so that a daily schedule of "what's on" can be printed.
I need to insert additional lines for the additional day...
|
8 |
30.09.2006 21:38:44 |
|
|
Extract and copy only letters from range
Hi. I have a list in column a of letters and numbers. I want to copy
the cells where there are letters (4letters) only and place them in the
same positon in column H - excluding all numbers.
Formula or vb?
Any clues?
...
|
3 |
30.09.2006 21:32:02 |
|
|
validate cells
In Excel, how can I validate that a cell has data? If there are blank cells,
I would like a message box when the user clicks on file to save or send. Any
help would be greatly appreciated. ...
|
7 |
30.09.2006 21:23:25 |
|
|
VARIABLE IN EXCEL MACRO
Try to copy various data from various places to another sheet using Excel
Macro, as this is required on a weekly basis.
However the data which needs copied is always in blocks, but the number of
Lines as well as the number of columns is changing.
Will need to take variable selection criteria in Excel macro as this is
possible in Excel.
Go to a certain cell
select an array using <End...
|
2 |
30.09.2006 21:19:13 |
|
|
Imports excel data to an sql table
I need to create a table with data from an excel book, I am new on this, if
someone can help me I'll appreciate it a lot. Thanks in advance....
|
4 |
30.09.2006 20:42:04 |
|
|
Macro or the fastest way to auotfile rows
I need a macros to autofill rows. I am working on one now but have a few
problems. I have one spreadsheet that has a row for each employee for each
payperiod. It has the employee name, check number, date, hours worked,
vacation sick, pay etc, earnings. The hours worked may be in 3 column
depending on if it is regular pay, overtime 1 pay, overtime 2 pay, and
commission - (which is an...
|
4 |
30.09.2006 20:07:42 |
|
|
Excel shows 12:00am as timestamp?
Hi all,
I'm trying to make excel display the current date and time in one
column when I enter a value into another column. The code I have is as
follows:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range
For Each Cell In Target
With Cell
If .Column = Range("C:C").Column Then
Cells(.Row, "F").Value = Int(Now)
End If
End With
Next Cell
End Sub
It works but doe...
|
5 |
30.09.2006 19:24:38 |
|
|
Loop through cells and run function
How can I loop through rows 14 to 33 and set the value in the A cell
returned by this function for each rows:
Range("A14").Value = CalculateScore(B14, C14, D14)
Regards,
S
...
|
4 |
30.09.2006 17:50:42 |
|
|
Text box format
I hope I explain this right.
In the process of displaying information on a sheet I have created a
form that displays measurments in different text boxes. These values
are looked up as you enter manufature and model number into a couple of
combo boxes.
I also use a check box to switch the values on the worksheet between
metric and imperial measurments.
What I need to do is format my text...
|
5 |
30.09.2006 17:28:35 |
|
|
Delete Rows then Move Up
Hi...
I have 3000 records. In column B there are sporadic #N/A values. I need some
nicely packaged code that will delete all rows where a #N/A appears in B, so
that there are no gaps in the rows. Sounds easy but I'm struggling.
Any help would be most appreciated.
Thanks
Gordon......
|
10 |
30.09.2006 17:23:24 |
|
|
Problem trying to generate a report with a formula
Hi all,
I'm trying to generate a report and am having trouble with the formula.
Any help would be greatly appreciated.
Here is what I need to be able to do.
I have 6 worksheets in the same workbook, worksheets 1 - 5 are
identically laid out and the sixth is the one I want to generate a
report on. Column A is for peoples names, Columns B-H are labelled
Monday - Sunday on top. If ...
|
2 |
30.09.2006 17:16:12 |
|
|
Mode() that works with string's
I'm trying to get a function to return the mode of a range, but unlike the
standard MODE() built into excel I need it to work with text strings. I
already know of a couple ways to do this with built-in Excel functions
(below) but the problem is these get very sluggish when using large ranges.
They also don't work when using ranges with multiple columns.
INDEX(rng,MODE(MATCH(rng,rng,0)))...
|
1 |
30.09.2006 17:16:02 |
|
|
Delete Every 2nd & 3rd Row
Hi,
I need to find a quicker way to delete every 2nd & 3rd row of three rows.
e.g. Delete Row 2 & 3, then 3 & 4, then 4 & 6. Can anyone help?, The below
does it but requires me to add a statement for each set of three rows, as
the data can vary from 3 rows to several thousand, I need something more
automatic.
Sub Macro1()
'
'
Rows("2:3").Select
Selection.Delete Shift:=xlUp...
|
3 |
30.09.2006 17:03:39 |
|
|
Interpolating missing data
Hi all,
I am a novice at this so please make allowances, I am looking to use a
vlookup function to access a 2D matrix of data, the problem is that the
2D data is only partially complete (currently ~20%). What I would like
to do is fill in what I do know and have excel interpolate the interim
values. I am only interested in the interim values and not
extrapolated, so I think the trend funct...
|
2 |
30.09.2006 16:32:29 |
|
|
programming a macro to display the current time
Can someone tell me how to code a macro to display the current time is a
cell. I am able to get the date and time with using the Now coding, but can't
seem to get the only the hours and the minutes. I know this is an easy
fix...but help I'm a newbie...
|
5 |
30.09.2006 16:29:01 |
|
|
Rename Excel Files
Hi All,
I have a group of about 20 Excel files in C:\Cars.
All the files begin with 5 zeros. For example 00000_redcar.xls,
00000_bluecar.xls.
I need a macro to replace the zeros in each file with another 5 digit
number.
For example 00000_redcar.xls would change to 12345_redcar.xls,
00000_bluecar.xls would change to
12345_bluecar.xls etc for all the files in the C:\Cars directory.
Thanks s...
|
5 |
30.09.2006 15:36:06 |
|
|
Does *Anyone* know how to....
I'm desperate! Have spend hundreds of hours
trying to resolve this issue.
How can you import (or Link) from Excel into Access
without getting a million "#NUM!" in place of the data???
I've read countless articles, theories, codswallop
no mortal could hope to understand and all I achieve is to see more of
them permeate through my data. I could happily
throw the dam computer out the win...
|
2 |
30.09.2006 15:27:01 |
|
|
VARIABLE IN EXCEL MACRO
Hi
Need the instruction for a manual input of a variable during/in an Excel
Macro, while the user is informed by a message what kind of variable is
required and where the input is restricted to a certain format (date
30-Sep-2006)
...
|
2 |
30.09.2006 15:19:02 |
|
|
Delete Rows with Empty Cells with empty column 1
My below sub below corectly deletes any rows that have empty cells within a
hard-coded range of A1:A150. What I'd like to do is to search the entire
range of cells containing values and delete any rows that have empty column
1 cells.
It would achieve the same reults as my current code, but I could get rid of
my hard coded reference. I never will know how many rows my spreadsheet will
...
|
4 |
30.09.2006 12:48:27 |
|
|
Get default add-in path
What is the best way to get the default .xla add-in path?
Will this always be Application.UserLibraryPath ?
Or should I use a function like this:
Function GetDefaultAddinPath(Optional strIdentifier _
As String = "\addins\") As String
Dim i As Long
Dim lCount As Long
Dim lPos As Long
strIdentifier = UCase(strIdentifier)
lCount = Applica...
|
3 |
30.09.2006 11:58:31 |
|
|
Visual Source Safe communication
Question:
I have an Excel VBA application that needs to communicate to Visual Source
Safe.
Upon researching the topic, I understand that one can do this in VBA, but
dont quite understand how to go about doing this.
Application does talk to both MS Access (for database communication) and MS
Outlook (for emails).
I'm guessing, the method is more / less the same mechanism where...
|
1 |
30.09.2006 11:42:01 |
|
|
go to end of ROW
hi,
I have the following:
Range("G6").Select
Range(Selection, Selection.End(xlToRight)).Select
The opnly problem is that G6 is empty, so when the command executes, it goes
to the very next cell to the right, instead of the true last cell to the last
where data has been entered.
How can I get it to go to the last cell to the right where data has been
entered?
Thanks in advanc...
|
12 |
30.09.2006 11:30:49 |
|
|
TreeView mousemove event
Hi,
I have a TreeView on a userform and I would like to show some
information on a label based on the current node (not selected) over
which the mouse is moving.
I made many searches in googles and could not find a code snippet on
this.
Thanks for your help.
Regards,
Karim
...
|
5 |
30.09.2006 11:15:24 |
|
|
Delete Rows Filtered within Auto Filter
Hi...
I have 3000 records. I want to delete 300 rows that share an auto filtered
value. The problem of course is that when I highlight the block to delete, it
deletes the rows that have't been filtered. Is there a way round this?
Thanks
Gordon......
|
2 |
30.09.2006 09:38:53 |