Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1829503%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1829503%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20is%20the%20formula%20to%20bring%20information%20from%20one%20tab%20into%20the%20summary%20tab%20but%20when%20dragging%20the%20formula%20to%20the%20next%20cell%20it%20automatically%20takes%20that%20same%20information%20from%20the%20following%20tab%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20my%20expense%20summary%20tab%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22momari2020_0-1603915003152.png%22%20style%3D%22width%3A%20693px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229918i4A3352435A1D4B91%2Fimage-dimensions%2F693x26%3Fv%3D1.0%22%20width%3D%22693%22%20height%3D%2226%22%20role%3D%22button%22%20title%3D%22momari2020_0-1603915003152.png%22%20alt%3D%22momari2020_0-1603915003152.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20for%20this%20is%20tabs%20associated%20with%20the%20years.%20I%20need%20to%20copy%20the%20formula%20to%20the%20next%20cell%20and%20it%20should%20automatically%20bring%20in%20the%20info%20from%20the%20relevant%20year%20tab.%26nbsp%3B%20sorry%20if%20this%20doesn't%20make%20sense%20hopefully%20someone%20out%20there%20understands%20it%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

What is the formula to bring information from one tab into the summary tab but when dragging the formula to the next cell it automatically takes that same information from the following tab?

 

This is my expense summary tab

momari2020_0-1603915003152.png

 

The data for this is tabs associated with the years. I need to copy the formula to the next cell and it should automatically bring in the info from the relevant year tab.  sorry if this doesn't make sense hopefully someone out there understands it :)

 

0 Replies