Forum Discussion

momari2020's avatar
momari2020
Copper Contributor
Oct 28, 2020

Excel Formula

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

 

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 🙂

 

No RepliesBe the first to reply

Resources