Microsoft Excel Tips and Tricks: Difference between revisions

From Free Knowledge Base- The DUCK Project
Jump to navigation Jump to search
Newer edit →
 
mNo edit summary
Line 1: Line 1:
=== Refer to cell in another worksheet ==


Reference the worksheet name like this:  sheet1!C12
In the example there is a worksheet for each month of the year.  To reference a value in cell E7 from the January worksheet in the February worksheet do this:
  =January!E7
=== Increment month by one ===
Easy way but not always accurate, just add the number of days to next month:
  =DATE(2009,1,15)+31
Use EDATE from Analysis Toolpak (Tools>Add-ins and check Analysis Toolpak)
  =EDATE(A1,1)
With the Date function
  =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
 
 


[[Category:Computer_Technology]]
[[Category:Computer_Technology]]

Revision as of 11:46, 26 January 2009

= Refer to cell in another worksheet

Reference the worksheet name like this: sheet1!C12

In the example there is a worksheet for each month of the year. To reference a value in cell E7 from the January worksheet in the February worksheet do this: 

 =January!E7

Increment month by one

Easy way but not always accurate, just add the number of days to next month: 

 =DATE(2009,1,15)+31

Use EDATE from Analysis Toolpak (Tools>Add-ins and check Analysis Toolpak) 

 =EDATE(A1,1)

With the Date function 

 =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

 

 

Retrieved from "http://wiki.robotz.com/index.php?title=Microsoft_Excel_Tips_and_Tricks&oldid=3871"