Is there a way to program a macro so that when it is run, first a
window pops up asking the user to enter in a date.  Could I then use
this date in the same macro? (i.e. I want to just pull the data that
was entered in the month the user requests).  Thanks!

I want to create a formula to annualise a persons income based on their
gross financial year to date income.
Assuming that the financial year begins on 1/7/06. The variables would be:-
Financial year start date (1/7/06)

I have a range of data in column A. I want to be able to run a macro
and paste it into another column (C). Then later when i make a change
to the data in column A, i want to be able to paste it into the next
available column (in this particular example it would be column D).

pls. help me to integrate this macro
i am trying to make a macro that will resize the Y-axis scale of a line
chart based on formulated cell values...
i got this error message

Please provide vba code to create PDF files for each worksheet in a workbook.
Each PDF file (using CutePDF) will be titled according to the contents of a
cell
This sounds very easy, but I've had much trouble in executing.

I have a need to combine two columns, which I can do using the features from
PUP 6. What I would like to know how to do before I combine the columns, if
any of the cells in one column, (bracket) that information before combining

I'm using the web query function inside Excel 2003 to import tabular
data generated by a php file (also done by me).
I'd like to place some formulas inside the table generated by php and
up to now, i've been able to write directly to it and successfully

I'm not sure if this can be done and if it can I may be going at it
all wrong, but I have a combobox that adds items as I type, say if I
type "B" it adds all items from my list that begin with "B", Now what
I'm trying to do is make it so when I type the next letter it deletes

One Cell contains a Due Date, and a second cell contains a Completed Date.  
1.  I would like to have the background of the Due Date cell to change to
yellow only when the date in this cell is within one week of todays date and
the Completed Date cell is still null, otherwise the ...

This post is aimed at those who have 'experimented' with the new
XL2007 Menu and are familiar with the 'Custom UI Editor'. I have very
little knowledge of XML
For those interested (and did not know) MS XML Notepad is available

If FtpFail = True Then
MsgBox "Order has been successfully Exported."
Else
MsgBox "Order has been saved but it has not been exported. Please check your

I need assistance with programming a spreadsheet used for collection of
rents. I want a small window to be used for the Appartment #, which shows the
tenant's name, the date is entered, the amount of rent received is entered
and the results are then transferred to the respective ...

We have a worksheet that lists Customer invoices the breakdown is from
Column A to Column M and rows 1-500 and every month we send an invoice to
each customer. In Column M when the customer settles their invoice I enter
the letter P in the cell, so that we know its been paid. It ...

I need help with replacing values in formulae with links.
I inherited supporting several Excel workbooks with very involved formulae
involving links
For example:

I'm trying to set a chart (it's a Gantt chart I've built so the data
series' are quite complicated) so that it automatically expands to
however many tasks there are (between 1-25).  Is there a way to write
a macro that changes the source data for 5 different data series to