Automate cell entries and save for a copy/s

[hotrod]

I have a work in progress file on my hard drive whereby sheets are update hourly.
As I'm updating the hard drive file I want another file copy or copies on a shared drive to be updated at the same time.
Is there a way to automate the process without having to save as all the time.
Can the process be done without the file copy/s open.
Thanks for your help in advanced.

 

[hsk]

How many cells you want to link ?
If not too many, you can directly put formulae in the "Shared Drive" sheet pointing to corresponding cells in the "hard drive" sheet

Go to Shared Drive Sheet - A1 - formula ='C:\......path\[sheet.xls]Sheet1'!A1

(or open shared drive sheet, select the cells you want to link, copy
go to shared drive sheet - Paste Special - Paste Link)


On opening the shared drive sheet, it will prompt you for updating the sheet, select "Update" to get the latest data from linked sheet.


Hope that helps .........

 

[hotrod]

Hard drive file has 10 sheets, all are approximately 1-500 lines and A-Z columns.

Information transferred from hard drive to shared drive is not exactly the same.
Formula used ='[Copy of 2009 Australian.xls]Stock'!A1
Copied the first cell and Paste Special, All for the rest of the cells.

Diference is ...
Text size, not the same.
Text colour, not the same.
Fill colour of cells, there is none.
Cells, have 0 and should have nothing.
Borders, are missing.
Comments, are missing.

Is there a way to get around the problems?
Thanks

 

[hsk]

Formula will give only value .............
You are asking about the format .. (cell color, border)

I don't see anyway other than VBA to copy Format

Cells, have 0 and should have nothing.

insatde of =A1 can use =if(A1='',' ',A1)