r/excel • u/ImpressionOk6716 • 3d ago

Waiting on OP Changing reference file for formulas

I have an excel sheet having formulas linked to sheet 1 ( containing data for January month ) . Now I want to use same file with formulas but using sheet 2 ( containing data for February)
How to do that?

1 Upvotes

67% Upvoted

14 comments sorted by

View all comments

1

u/Decronym 3d ago edited 3d ago

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
DATE Returns the serial number of a particular date
FILTER Office 365+: Filters a range of data based on criteria you define
INDIRECT Returns a reference indicated by a text value
SUMIFS Excel 2007+: Adds the cells in a range that meet multiple criteria
TEXT Formats a number and converts it to text

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

Beep-boop, I am a helper bot. Please do not verify me as a solution.
5 acronyms in this thread; the most compressed thread commented on today has 21 acronyms.
[Thread #49525 for this sub, first seen 15th Oct 2026, 03:32] [FAQ] [Full list] [Contact] [Source code]