10-18-2009, 12:18 AM
Hi,
Please implemet this logic in your script, it may helpful to u
1.Lets take u r going to use 100records of data in excel sheet under sheet1
2. On first day u have done some transactions u many add some data or delete the data then copy the entire updated data and paste that data in sheet2(Day1)
3.Now you will do some transaction and add some data or delete some data then copy the entire updated data ana pste that data in sheet3(Day2)
;;;
;;;
;;;
like this proceed as many days u want
Finally if u wnat to make the summary sheet for all these sheets (1,2,3,4,5,6,7,8,.....)
Please get the required columns from different sheets and paste it in another excel sheet (Summarysheet)
This is the way u can proceed
Please let me know if i am going in wrong direction...
We could do the entore process by using vb script.
Please let me know if you need any thing apart from this..
Please implemet this logic in your script, it may helpful to u
1.Lets take u r going to use 100records of data in excel sheet under sheet1
2. On first day u have done some transactions u many add some data or delete the data then copy the entire updated data and paste that data in sheet2(Day1)
3.Now you will do some transaction and add some data or delete some data then copy the entire updated data ana pste that data in sheet3(Day2)
;;;
;;;
;;;
like this proceed as many days u want
Finally if u wnat to make the summary sheet for all these sheets (1,2,3,4,5,6,7,8,.....)
Please get the required columns from different sheets and paste it in another excel sheet (Summarysheet)
This is the way u can proceed
Please let me know if i am going in wrong direction...
We could do the entore process by using vb script.
Please let me know if you need any thing apart from this..