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.
what is the difference between the two spreadsheets, the way you describe it makes it sound like they have the same information.
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.
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.
