Coping data between worksheets

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am trying to copy data from one worksheet to another
worksheet within the same workbook automatically. I have
totals from one month to another and need to have the
ending totals to move to the next month. It seems like
it should be a pivot table but I havent used that
function before.
 
Hi
if your ending totals are always in the same cell position you can
easily reference a different worksheet. Try the following:
- on your second worksheeet select the target cell and enter the
equation sign '='
- activate the first sheet (with your mouse) and select the totals cell
- hit ENTER

your formula shoud look like
='first_sheet_name'!A10
of course you can enter this formula directly
 
Back
Top