We save daily process sheets by date in a monthly work book which also
contains a master sheet. How could I write a formula to automatically copy
the data, by the date spreadsheets, into the corresponding cell on the
master(by date)? On any given day there could be anywhere from 100 to 450
entries.

A formula can't "copy" data, it can only reflect data or a manipulation
of it, to actually copy the data you would need to use VBA, for that you
need to kow form which sheet to which sheets and where your data starts.
It would be a good idea if you could post a sample workbook.

Locustladies;309247 Wrote:
We save daily process sheets by date in a monthly work book which also
contains a master sheet. How could I write a formula to automatically
copy
the data, by the date spreadsheets, into the corresponding cell on the
master(by date)? On any given day there could be anywhere from 100 to
450
entries.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86461

Thanks for the help. I made a little book to show you what I mean. How do I
get it to you?

"Simon Lloyd" wrote:


A formula can't "copy" data, it can only reflect data or a manipulation
of it, to actually copy the data you would need to use VBA, for that you
need to kow form which sheet to which sheets and where your data starts.
It would be a good idea if you could post a sample workbook.

Locustladies;309247 Wrote:
We save daily process sheets by date in a monthly work book which also
contains a master sheet. How could I write a formula to automatically
copy
the data, by the date spreadsheets, into the corresponding cell on the
master(by date)? On any given day there could be anywhere from 100 to
450
entries.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86461

You can do a couple of things, you could join our forums (shown in the
link below) it's completely free, if you do join you will have the
opportunity to add attachmnets to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so, or you could upload your workbook to a site where it can be
downloaded from, or you could email it to me but i won't get it until
tomorrow at simonDOTlloydATthecodecageDOTcom (of course substitute the
words in captils for what they should be)


Locustladies;309487 Wrote:
Thanks for the help. I made a little book to show you what I mean. How
do I
get it to you?

"Simon Lloyd" wrote:


A formula can't "copy" data, it can only reflect data or a
manipulation
of it, to actually copy the data you would need to use VBA, for that
you
need to kow form which sheet to which sheets and where your data
starts.
It would be a good idea if you could post a sample workbook.

Locustladies;309247 Wrote:
We save daily process sheets by date in a monthly work book which
also
contains a master sheet. How could I write a formula to
automatically
copy
the data, by the date spreadsheets, into the corresponding cell on
the
master(by date)? On any given day there could be anywhere from 100
to
450
entries.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' ('http://www.thecodecage.com'
(http://www.thecodecage.com/))

------------------------------------------------------------------------
Simon Lloyd's Profile:
'http://www.thecodecage.com/forumz/member.php?userid=1'
(http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread:
'http://www.thecodecage.com/forumz/showthread.php?t=86461'
(http://www.thecodecage.com/forumz/sh...ad.php?t=86461)




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86461