Change formulas based on date
Wed, 23 Jul 2008 01:36:16 GMT
I have an issue that I haven't been able to find an answer to, that I'm
hoping somebody can help me with. I have a pretty involved spreadsheet that
is used to calculate the residual value of various vehicles. I've been able
through either VBA or formulas to handle most of what I need to, but there's
one section ...
|
macro to delete all digits to the right of decimal place
Tue, 22 Jul 2008 18:27:01 -0700
I want to create a macro that will round a number with decimal places up and
then delete all the numbers to the right of the decimal place and the decimal
place it self. So I am hoping that it will take a cell that has
49938.523566 and turn it into 49939 but if it was 49938.4235666 it would turn
it into 49 ...
|
Re-scale a bubble chart
Tue, 22 Jul 2008 18:26:00 -0700
Does anyone know how to programatically format a bubble chart's axis?
I have an Access database that processes all of the data, then outputs this
to Excel. In Excel, there are already a number of tables and charts set up
which pick up this output with no problems. However, the only things that
don't update ...
|
macro to copy data to master workbook.
Tue, 22 Jul 2008 17:56:11 -0700 (PDT)
Hi All
I have 50 workbook in a folder, say wb1, wb2 ...wb50. Every sheet1 of
each workbook has some data in first say 20 lines.
What iam trying to do is run a macro in a master sheet, that will copy
the data of each sheet1,one below the other and also add a column
telling me the wb it is coming from. Look exa ...
|
Data Validation List Hide Unhide Rows
Tue, 22 Jul 2008 17:09:05 -0700
Hello,
Let me start by saying, I have years of excel experience, but very little
VBA experience.
I currently have a data validation list with 8 options. My goal is to have
the user select an option, then have a section expand just below that, based
on what they select.
I have attempted to write a macr ...
|
GetObject when more than 1 Excel is running
Tue, 22 Jul 2008 15:41:00 -0700
From within VB.Net, if I want to access an instance of Excel that is already
running, I'd use something like.
dim Exc as Excel.Application
Exc = GetObject(, "Excel.Application")
However, suppose I have more than one instance of Excel open. Is there a
way to cycle through each open instance, and to pick a s ...
|
forms - how to fill each line in a record
Tue, 22 Jul 2008 23:21:53 +0100
sorry to ask such a basic question but I can't find the answer anywhere.
When you use FORM on the DATA menu to enter information, it automatically
moves to the next line when you hit 'NEW'
How does that work when you use the data entry tools on the FORMS toolbar? I
can populate a specific cell with data fr ...
|
|
|
refer to a cell for password
Tue, 22 Jul 2008 15:19:04 -0700
I have built VB code that refers to a cell on a sheet for the password to
protect the sheet.
I now need to protect the VB code and would like to use the same cell
reference for the password - that way the password only needs to be changed
in one place (rather than using the properties>protection dialog box ...
|
parse excel file
Tue, 22 Jul 2008 15:12:03 -0700
hello,
hope to get some help here.
i need to parse some big batch of excel files, some general question:
( the excel file contains some data pages ad a summary page, kind of like a
report)
I need to look at the content of each cell, then decide what to do next, for
example, if the cell says ' total ...
|
Problem with drag and drop formatting
Tue, 22 Jul 2008 14:56:01 -0700
I have a database that uses zip codes to find data about reps and filll a
userform. My problem is that large ranges of zip codes have more than 1 rep
covering that area and therefore I have had to create multiple entries for
many of the zip codes. The problem is when i create a series of zip codes
such as ...
|
