On spreadsheet 1, I have a company name in cell A1, then in cell b1 the start
date for the company.  I have a formula that calculates 6 future appointment
dates based on the start date in cell B1.  The future appointment dates are
shown in cells B2, B3, B4, B5, B6, B7.  

Hello Friends,
This group has been of great help for all starters like me. Thanks a
lot!!
It would be great if somebody could please help me with one of my

I am trying to make a 2 sheet workbook which has the input details in Sheet1
A1 and this is changed weekly but the info in this cell should then be
inserted into the first blank cell in Column A in Sheet 2.
I have tried this code (below) but it doesn't seem to work and maybe I am

I have to set up some sort of budget management tool for my work place.  
Because it's not me who's doing the data entry for this, I need to design it
so that it's lazy-proof.  Unfortunately, Access is not an option.
Basically, here's what I'm trying to do:

I have a real problem that is doing my head in!
I have a sheet that is filled in every week with figures from 45 different
companies - each company has a line with, say, column C being the input
column which then works out the amount minus VAT and places it in column D.

Hey guys
I have been using the following formula in VBE and it was working just
fine now i want to add more data in th emain sheet so i tried to open
the view code to edit the range but i hav ereceived the following

I would like to create a file of data that has quanties used from one time
period.  Then, periodically take another file of the same items from another
time period and bump it up against the first one. I want to match the items
and put the usage quantities side by side.  Then ...

<<Previously posted in m.p.e.charting under "Graphics Filename via
Formula">>
I am trying to programmatically generate a 9-panel chart similar to
those you see in stock prospectuses, with the horizontal displaying

I need to get data from messages in Outlook to fill fields within Excel
worksheet using VBA. Can anyone suggest me a website or ebook where i can
obtain information?
Thanks in advance

I am creating a shipping schedule template and have 9 weeks that I ship
products. I would like to show each customer how many units they receive per
week.
My template is set up for 9 ship weeks. Here is an example for 3 shipments.

The following query works fine :
SELECT [Base Data].[Scale Max] AS Old, [Base Data].[New Scale Max FTE] AS
New, [New]-[Old] AS Diff
FROM [Base Data];

I have a vista version spreadsheet and I want to change print area. However
the "print area" tab is gray and does not respond ..as are a few other tabs .
How do I clear this to allow changes?

I have a pivot table with line items that only show the "collapse" button
because they do not contain any information to show the "expand" button. Does
anyone know why the "collapse" button appears when there is no data to expand
or collapse? Can this "collapse" button be turned ...

I thought I was getting this message when I refresh one pivot because I had
multiple pivot tables on a worksheet.  Whether I select Yes or No
("overwrite" or "don't overwrite") it deletes data from the two pivot tables
to the right of it (the rest of the pivots to the right ...

I have an Excel 2000 spreadsheet with 2 sheets in it that is my Purchase
Order Log.
Sheet1 =  "2008 Jobs"
Column A = Job numbers