Auto update spreadsheet

[joz]

Anyone knows how to auto update data in spreadsheet ??

i have 1 workbook ie. the summary that should retrieve datas from other workbooks.

Workbook A is the summary
eg.
Sheet 1 named: 14 Mar
Sheet 2 named: 20 Mar

eg. my database
Workbook B name: 14 Mar

Workbook C name :20 Mar


I need to create multiple sheets in workbook A and named via specific dates. What other way can i auto update worksheets in A when i have created for new database. This will be on continous basis.

pls advice... anyone

[Simon Lloyd]

You need to link your workbooks look here and here for some good help on how to achieve and manage this!

[joz]

hi Simon, both links you provided doesnt meet my requirement. Anyway i tried to edit 1 cell with formulas and change the [source] name, now if i go to Edit, Links, i could see my source in the template.

I cant remember the steps i did that helps me to amend in 1 cell on the source, and the rest of the cells could update to the new source. I did not use the "replace" function. All i did was toggling between the update and change source.

Any idea how i could i go about it ?