View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike1558 Mike1558 is offline
external usenet poster
 
Posts: 12
Default transfering cell values progressively through worksheets

What I am doing is, say for the pay-app month May, I have a cell that
contains the total amount of a line item for this draw period. The next cell
in the row contains a formula that gives the results for the amount for this
line item spent to date. To one of the values in "spent to date" cell comes
from the same cell in a previous worksheet "April". Once the "May" worksheet
is done and I move on to create the "June" worksheet the "May" amount now
becomes a value in the "June" worksheet. This happens progressively through
the completion of the job. Do you have a suggestion? Would it be helpful to
see what I am working on?
I really appreciate any help you can give me.
Also I am having an annoying problem with all my excel workbooks, I have
office 2007, when I try to select a single cell it selects multiple cells
then what I do is move the curser to the lower right hand corner of the cell
that I want to select and I have to keep clicking on it until the single cell
that I want is selected. This usually takes several attemps because a cell in
the vacinity of the cell that I want gets selected not the cell that I want.
Any suggestions?
--
Thanks
Mike


"Kassie" wrote:

Only with a LOT more information?
--
HTH

Kassie

Replace xxx with hotmail


"Mike1558" wrote:

I am creating a budget/pay-application template that uses a new worksheet for
each pay-application and the number of worksheets corrisponds to the duration
of the job. Within these worksheets are cells that contain formulas that
produce values and these values need to be entered into a formula that creats
an new value for next pay-application period. Does anyone know how to do
this, any help will be greatly appreciated.
--
Thanks
Mike