Copying data between diff excel sheets [Closed]

Report
Posts
1
Registration date
Wednesday December 8, 2010
Status
Member
Last seen
December 8, 2010
-
 Anne -
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



1 reply

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!