automatically paste values from a different file
 

i am making a daily accounting sheet for my business and i want the
total business values for today to appear automatically onto the next
day's accounting sheet.

for example

june 6, 2006
today's revenue: $45.00
monthly total yesterday: $85.00
total for month today: $130.00 (=sum of 45 and 85)

june 7, 2006
today's revenue: $50.00
month tot.yesterday: this is where i need the $130 to automatically
appear from the last day
total for month today:

thank you

automatically paste values from a different file
 

Are you using multiple sheets in one workbook? And if so how are they
named?


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=552423

automatically paste values from a different file
 

no i am using just one sheet but several files

kraljb wrote:
Are you using multiple sheets in one workbook? And if so how are they
named?


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=552423