In Sheet1, data i have
A                            B
EMPCODE           AMT
F001                       2

I'm posting this question on behalf of a colleague, so hope I have
understood the question correctly.
He has a spreadsheet with an ascending list of dates (column D).  In column
A he is wanting to show the next date.

I want to grab the data from cells A2/A10/A18 etc
I thought if I did the first few and then selected them all and copied that
excel would get the idea and grab every 8th one, but it doesn't
Is there a formala that can say get cell that is previous one plus 8 rows?

I have a gannt chart/programme on Page 1 which uses NOW() to calculate
programmed progress of each work activity according to the number of days
after the start date. I also have a column where the estimate of work is
manually entered.

Hi. I have two excel files, Excel-1 and Excel-2. I must copy from Excel-1 to Excel-2 only some columns (for example A,B,D and G). After this copy, in the Excel-2 file, i must search in a column (A) for duplicates. If i found one, a script must delete the entire row. (for example ...

I am trying to find a formula that compares the data from one worksheet
to another. If the data matches I want data from another column on the second
page.
Example

How can I get Excel (2003) to return just the first 4 words of another
cell?
With thanks
Ship

I have createda spreadsheet which includes separate workbooks with figures
for each month of the year, I have also created a workbook within this
spreadsheet which is for the yearly figures but i cant seem to figure out how
to create the right formula to add the data from the ...

I have data range  L5:L100 which contains numbers. I want an event
proceedure which hide the rows if cell value is equal to zero.
Further i want this event proceedure assign to a button. Clicking on
it will perform the above task

I am trying to count the number of occurances of two critera happening
but none of the results listed are helping.
example of what I am trying to do:
Region            Product           Sales

I have two colomns of data, I need to operate the count function only if the
data in both colomns, within the same row are true i.e
I need to count the how many times the trade "car" happens to be a priority
"2".

I cannot drag  cell that has content that I want t copy to other cells in the
same row or column. I used to point my curor to the lower right corner of the
cell and a littl symbolused to appear and then I just had to drag the cell
and the contents would be copied. Why is it that ...

To determine if a date falls within a time period, I created this
function, but keep getting #NAME? for the result.
=IF(AND(7/1/2005<=AE,AE<=6/30/2006),"FY2005","NA")
This function is in AF, where the result would be placed.

Is there a simple way to count "odd" numbers in a column/row?  And is there
any limit on the size of the actual number?
Thanx in advance...

I need to update the data in a specific cell whenever 14 days has passed.
That is I want to add a nominated $ amount every 14 days. I use the formula
=A21-Start_date to determine how many days have passed from the start date.
The cell that shows this updated data is not the one ...