Can anyone help me - refer me to a template example? I have bee
writing (or attempting to) various stuff in excel but am stil
learning.

I have written a spreadsheet/programme that i use for various projects
The programme contains around 10 worksheets that users have to ente
info into.

It is a large programme, and is now nearly 1mb in size, also i a
constantly improving/updating.

Is there any way that i can say copy all of the data in all worksheet
(i.e. cell contents - not worried about formatting) onto 1 sheet, an
then saving that sheet as say the data file. When the user then open
the programme, they enter which filename that they wish to work wit
and it imports all of the data from the data file into the correc
place on each worksheet.

Is there also a way that the user can export sheets to another file t
send by email for someone to use e.g export sheet 1 and 5 (will nee
the formatting but not worried about the calculations etc), so that th
outside party then has the data but not the programme workings (o
size).

Thanks for your help in advance as i have been trying to crack this on
for ages and haven't got very far

--
Welsh
-----------------------------------------------------------------------
Welshy's Profile: http://www.excelforum.com/member.php...fo&userid=1601
View this thread: http://www.excelforum.com/showthread.php?threadid=27484