Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() hi, i am fairly educated with Excel, but i am having problems with my company's working hours spreadsheets. Basically, we have two spreadsheets (05/06 and 06/07) what i wish to do is to import the data from the 06 part of the 05/06 sheet into the relevant area of the 06/07 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 in the 06/07 sheet, i go to import the data, select that i wish to overwrite the cells. Everything goes fine until the data actually copies over. It sucessfully imports *BUT* it misses the odd value, here 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 hours now with very little luck! Please please help me =] Many thanks in advance. -- koldtooth ------------------------------------------------------------------------ koldtooth's Profile: http://www.excelforum.com/member.php...o&userid=35406 View this thread: http://www.excelforum.com/showthread...hreadid=551793 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |