Any way to make a formula like a default Ex:
=b2-c2 where b2 and c2 can be any cell, without typing every time = the cell and the minus sign, I need to subtract the dates of two adjacent cells, I need to do this about 6000 times
Any way to make a formula like a default Ex:
=b2-c2 where b2 and c2 can be any cell, without typing every time = the cell and the minus sign, I need to subtract the dates of two adjacent cells, I need to do this about 6000 times
Last edited by hcastro; 08-08-2013 at 08:53 PM.
Type the formula ONCE, exactly like you've shown.
Now you can copy that cell and paste it over the other cells where you need the formula. As long as the relationship between where the reference cells are and the formula cell is stays constant.
FOr instance, you put that formula in D2, the copy D2 down column D and it would adjust itself for each of the rows below that.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks