importing data from other sheet

K

koldtooth

hi, i am fairly educated with Excel, but i am having problems with m
company's working hours spreadsheets. Basically, we have tw
spreadsheets (05/06 and 06/07) what i wish to do is to import the dat
from the 06 part of the 05/06 sheet into the relevant area of the 06/0
sheet to save me the hard job of typing it all out!

I have named the area of which i want in the 05/06 sheet. And then i
the 06/07 sheet, i go to import the data, select that i wish t
overwrite the cells. Everything goes fine until the data actuall
copies over. It sucessfully imports *BUT* it misses the odd value, her
and there. And if i manually enter it myself, when the page refreshes
the cell is made empty again.

I do hope this makes sense as i have been working this out for 3 hour
now with very little luck! Please please help me =]

Many thanks in advance
 
R

robert111

make a copy sheet of the 0506 spreadsheet using edit, move or copy
sheet, and check create a copy. Then add your new columns from April
1st onto it.
 
K

koldtooth

thats good, and thankyou for replying =] but it still doesnt update.
what i want to accomplish is, when i enter data on the 05/06 in the
months during 2006, it automatically updates on the 06/07 sheet, sorry
if i havent been clear
 
K

koldtooth

hey not to worry =] i managed to accomplish it with a few complex Macro
=] thanks for your help anyway
 
Top