Copying data between diff excel sheets
Closed
mohanadeepan
Posts
1
Registration date
Wednesday December 8, 2010
Status
Member
Last seen
December 8, 2010
-
Dec 8, 2010 at 11:28 AM
Anne - Dec 8, 2010 at 11:46 AM
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
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
Related:
- Copying data between diff excel sheets
- Transfer data from one excel worksheet to another automatically - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Sheet right to left google sheets - Guide
- Tmobile data check - Guide
- Mark sheet in excel - Guide
1 response
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
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
