how move static data cells to follow their corresponding month using Today function in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1097693%22%20slang%3D%22en-US%22%3Ehow%20move%20static%20data%20cells%20to%20follow%20their%20corresponding%20month%20using%20Today%20function%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1097693%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20understand%20how%20I%20can%20best%20force%20static%20cell%20block%20to%20move%20forward%20or%20follow%20their%20corresponding%20Months%20in%20Excel.%3C%2FP%3E%3CP%3EI%20am%20doing%20a%20forecasting%20report%20where%20the%20monthly%20sales%20volume%20is%20largely%20static.%20However%2C%20when%20I%20open%20the%20report%20in%20a%20new%26nbsp%3B%20month%20using%20the%20Today%20function%20the%20sales%20volume%20stays%20in%20its%20original%20column%20thereby%20no%20longer%20matching%20up%20with%20the%20month%20it%20matches.%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1097693%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1097961%22%20slang%3D%22en-US%22%3ERe%3A%20how%20move%20static%20data%20cells%20to%20follow%20their%20corresponding%20month%20using%20Today%20function%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1097961%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F511210%22%20target%3D%22_blank%22%3E%40timATC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20you%20to%20obtain%20ideas%2C%20please%20attach%20your%20sample%20Excel%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

Can someone help me understand how I can best force static cell block to move forward or follow their corresponding Months in Excel.

I am doing a forecasting report where the monthly sales volume is largely static. However, when I open the report in a new  month using the Today function the sales volume stays in its original column thereby no longer matching up with the month it matches. 

Any ideas?

Thank you

1 Reply

@timATC 

For you to obtain ideas, please attach your sample Excel file.