I have two questions related to formula management
1) When I'm creating a formula and taking a section from another tab, how can I go back to the original tab where the formula is being written, without have to click the tab itself?
2) This formula i s in E3. =SUMIF(June!C:C,Sheet2!C3&"-"&Sheet2!B3,June!E:E)-SUMIF(June!C:C,Sheet2!C3&"-"&Sheet2!B3,June!F:F)
How can I move it to D3 without having any of the references move?
Last edited by ammartino44; 07-24-2015 at 06:44 PM.
Absolute them?2) This formula i s in E3. =SUMIF(June!C:C,Sheet2!C3&"-"&Sheet2!B3,June!E:E)-SUMIF(June!C:C,Sheet2!C3&"-"&Sheet2!B3,June!F:F)
How can I move it to D3 without having any of the references move?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
2 .... Select cell E3, press F2 to go into Edit mode, select the whole formula in the Formula bar, Ctrl-C to copy it, Esc to come out of Edit mode, select cell D3, press Ctrl-V to paste it. done.
Sounds more complicated than it is.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I think there's something misunderstanding here. What ammartino44 seems to be asking is, when in the process of typing a formula that references a separate sheet, Example: Sheet1, in any cell, type =, then select any cell in Sheet2 (the formula will look like this =Sheet2!A1), how do you then, before hitting (ENTER), do you go back to Sheet1, without having to click on the Sheet1 tab itself.
My answer: No, I don't think there is a way to do so apart from 1) clicking on said tab, 2)Ctrl PageUP/DOWN it.
No misunderstanding, both TMS and myself answer the 2nd question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks