Can a spreadsheet update a spreadsheet that is not open

[pickwa]

Hi Guys,

I have several spreadsheets that need information extracting from them. for example number of entries on certain dates etc. I just wondered if it was possible to make a seperate spreadsheet that could collect the data.
Not a seperate tab a completely different document. The other spreadsheets that i require the data from will always be saved in the same locations.


I am guessing that this is a rediculous request but i just thought i would ask on the off chance that it may be possible.

Thank you in advance

 

[AkaTrouble]

have read here

Excel “Pull” Function: Creating dynamic links to closed workbooks | Numbermonger

 

[pickwa]

Thanks, much appreciated

 

[pickwa]

wow, that has just blown my mind.

 

[pickwa]

i have worked out how to add the code to my document but my excel knowledge is that bad i just have no idea how to write a formula to use the function.
=IF(NOW(),pull('[2013_2014_Record_of_Annual_Certificates_Derbyshire(1)with month totals.xlsx]Count'!$D$7))

this was my attempt at copying someone's example but evidently i do not have th right idea.

Could anyone point me in the right direction please

 

[AkaTrouble]

to check

firstly you did save the workbook as macro enabled and then reopen it before trying to use the UDF ( user defined function)

 

[pickwa]

I have now, sorry i bet i sound like a real dummy. The formula that i put in my above post still returns NAME? in the cell. Iam wondering if i am just out of my depth and perhaps i should take a different approach. it would just be so helpful to have all of the data in one place instead of having to open 11 spreadsheets to get at it