Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
wg pollard
 
Posts: n/a
Default IN EXCEL...I CANNOT COPY THE TOTAL LINE AND PASTE IT ...I GET REF.

I USE spreadsheets for monthly books...
at end of year i need to move the totals of each month to a yearly total
sheet...
when i highlite and copy the monthly total and paste to new sheet , i get
REF!

??? can u help me
  #2   Report Post  
ma01hh
 
Posts: n/a
Default

Hi,

There are two ways to solve your problem. The first will result in the data
being pasted in a way that it will not update if the monthly sheets change,
but it is simpler.
Copy as you have done, but right click in the top left cell of the cells you
wish to paste to and select 'paste special' from the list, hten select values.

The second way is to go to the first cell where you wish the values to be
pasted to, type = and then navigate to the cell containing the data which
will be displayed. This formula can be copied to the other cells so they read
in the data from each of the sheets, and the years data will update
automatically when the monthly sheets are changed.

The reason you had this problem was because you were trying to copy
formulas, so when you paste them they are trying to refer to cells in the
sheet you are pasting into.

Good luck

"wg pollard" wrote:

I USE spreadsheets for monthly books...
at end of year i need to move the totals of each month to a yearly total
sheet...
when i highlite and copy the monthly total and paste to new sheet , i get
REF!

??? can u help me

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro - - Automation Jac Excel Discussion (Misc queries) 8 December 27th 04 03:42 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 05:55 PM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"