I have a spreadsheet that I enter data in daily. Right now I am in the month of

Question

I have a spreadsheet that I enter data in daily. Right now I am in the month of January and each column is a day that I enter data in. So tomorrow I will go to the next column (to the right) and enter that days data. I have created daily spreadsheet that will automatically add that days worth of data when it is added to the monthly sheet. Is there a formula that I can use that will AUTOMATICALLY get the data daily from the first sheet and put it on the second? For example, I add data to Monday (on the monthly sheet).. I go to the second sheet and it's on there as well automatically. Is there a formula that I can use so that when it's Tuesday all I have to do is enter the data on the monthly sheet and it changes Mondays data out and puts Tuesday in that spot?

Explanation / Answer

hope this link will help u

http://office.microsoft.com/en-in/excel-help/create-a-link-to-another-cell-workbook-or-program-HP005199514.aspx

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.