Copying data between diff excel sheets [Closed]

mohanadeepan 1 Posts Wednesday December 8, 2010Registration date December 8, 2010 Last seen - Dec 8, 2010 at 11:28 AM - Latest reply:  Anne
- Dec 8, 2010 at 11:46 AM
Hello,
am working with multiple excel sheets for a daily sales entry, my first sheet would be on day sales entry, and my second sheet will be sales for the total month, for eg if am entering sales for today the datas must be copied to todays date on the sheet 2 , tomorrow ill changing todays data in sheet1 and ill be entering tomorrows data it should update in tomorrows date in sheet2, please help me , thanks in advance



See more 

1 reply

0
Helpful
Okay, try this . . .

1) Create 2 "Briefcases" on your Desktop.
2) In the first one, create and save your Excel document.
3) Right-click the Excel document icon and select "copy".
4) Double click the second Briefcase on your Desktop, right-click again, and paste your Excel document.

Now, you go into the second "pasted" Excel document and make the changes you need. When you want both Excel documents (in both of the different briefcases) to record the same information, then type into the first Excel document you created and save it. The go into the second Briefcase, right-click on the Excel document icon, and selct "update". What will that do?? Well, it duplicates the changes from the first one onto the second Excel document, leaving whatever you had there before as it was.

Hope this works for you!! Let me know if you have any questions. I know it is kind of comlicated, so you might not end up wanting to do it this way.

God bless!
A Fellow Questioner, Anne