Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
kraljb
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Rows Automatically using a Text File List mirdonamy Excel Discussion (Misc queries) 9 January 11th 06 11:11 PM
File automatically opens Brad Excel Discussion (Misc queries) 1 January 6th 06 05:00 PM
Copy and paste special - values into new excel file [email protected] Excel Discussion (Misc queries) 1 October 12th 05 11:02 PM
linked values not displayed unless source file open Sandyc Excel Discussion (Misc queries) 1 October 7th 05 02:18 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"