Excel : Insert Values From Another Wookbook

[Apex]

Just a quick question....

I need to be able to take a specific cell value from one work book and paste it into a new workbook.

So take cell A1 from

Phone Stats 01-06-2007.xls
and put it in A1 in Monthly.xls and so on
A1 in Phone Stats 02-06-2007.xls to A2 in Monthly.xls

Get the idea.

Now i want to be able to automate this if at possible

any pointers on this before i resort to reading the help files

[Nick F]

I'm pretty sure it's just a case of opening both workbooks and then in the cell enter "=" and then select the other cell you want to pull the information from.

[Apex]

Yeah from reading the help files it looks like it, shame there's not automated way to do this, having to do it for 30 workbooks is not fun

Might has well just wright down the values and put them in that way.

[toolsong]

You can automate anything with VBA but it won't be a simple macro recording you can extend.