Mobile/PDA About Us Advertise here
User User name Password  
  Not registered yet? Register here.
Lost your password? Click here. 		 
  Home   News   Guides   Downloads   Glossary   Hardware   Profiles   Forums   v4  
 Advertise at AfterDawn.com     Link to us!     Private messages     Compose a private message     List of all updated threads     Threads without replies     Search messages
Monday 2.12.2024 / 09:27
Search AfterDawn Forums:        In English   Suomeksi   På svenska
afterdawn.com > forums > software, operating systems and more > windows - general discussion > excel spreadsheet help
Show topics
 
Forums
Forums
Excel Spreadsheet Help
  Jump to:
 
Posted Message
charrell
Junior Member
_ 		14. January 2008 @ 18:28 _ Link to this message    Send private message to this user   
Good evening all I hope that I find everyone well.



Okay I have a question and this will be a 2 parter.



1st off I have Grid Magic on my BB 8100 and it works fine I tried it tonight by sending myself a file then opened it,Visually very small but yeah works fine.I want to be able to to work on my spreadsheets from work as well as on the road,so that part I think I have achieved.



I have 2 diffrent versions of the same excel file:

1 will be cumulative that I will send out once a week and.

2 will be a daily that I send out that will be a Daily,I need to know how I can link the 2 so that when I add new information to the 2nd Rpt I can automatically update the 1 Report with only the new information without having to cut and past the information back and forth.

Please let me know If I need to add more information.
Thanks in Advance.
[ + quote]
Charrell
omnicore
Junior Member
_ 		15. January 2008 @ 11:39 _ Link to this message    Send private message to this user   
what is the difference between the two spreadsheets, the way you describe it makes it sound like they have the same information.
[ + quote]
charrell
Junior Member
_ 		15. January 2008 @ 11:55 _ Link to this message    Send private message to this user   
One will be the Daily Rpt.the one that is updated Daily basically,
what happens is Rpt (1)is done daily but as things are cleared they will fall off this rpt to keep it somewhat small.
While the Cumulative Rpt. will have all information and will only be sent out once a month detailing all that has transpired for the entire year.
And I want to try and simplify this by being able to add daily info from the the Daily Rpt. and then do some kind of automated update that will carry over to the Cumulative Rpt,but I need to makesure that when I archive information from the Daily Rpt. that it does not remove any information from the Cumulative Rpt.
This really seems difficult and honestly I'm not sure that this can be done.

Any help is greatly appreciated.
[ + quote]
Charrell
Advertisement
_ 		__
 
_
omnicore
Junior Member
_ 		15. January 2008 @ 12:29 _ Link to this message    Send private message to this user   
It can be done quite easily in Microsoft Access, you would enter the data like you do in excel and then you can create a macro to export the weeks and months to excel or you can create a report and print it as a PDF for the week and month. I don't believe excel will be able to do what you want it to do.
[ + quote]
afterdawn.com > forums > software, operating systems and more > windows - general discussion > excel spreadsheet help
 

Digital video: AfterDawn.com | AfterDawn Forums
Music: MP3Lizard.com
Gaming: Blasteroids.com | Blasteroids Forums | Compare game prices
Software: Software downloads
Blogs: User profile pages
RSS feeds: AfterDawn.com News | Software updates | AfterDawn Forums
International: AfterDawn in Finnish | AfterDawn in Swedish | AfterDawn in Norwegian | download.fi
Navigate: Search | Site map
About us: About AfterDawn Ltd | Advertise on our sites | Rules, Restrictions, Legal disclaimer & Privacy policy
Contact us: Send feedback | Contact our media sales team
 
  © 1999-2024 by AfterDawn Ltd.

  IDG TechNetwork