Bad code on the template. Help needed :(

[dreamshaper]

Hey guys & Gals

I am trying to use the "online sales tracker" template provided by microsoft but I am finding that from march on the values don't automatically calculate like they do in jan, feb, march. I tried all sorts of things but no luck

It cant also be copy and pasted because i want the final sheet which adds up the whole year and gives a neat summary. ANy help ? thanks

 

[Debraj]

Hi dreamshaper!

Welcome to the forum..

I guess you already have throughly checked all the area in Jan,Feb & March.. but did you checked the Column L..
"Sale profit/loss".. IN JFM.. Column A has a formulas.. however.. from April .. that formula is missing..

Try to copy the formula from any JFM sheet, and apply the formula in other Sheet's Column L..

Hope it will work..

Let us know the feedback..

dreamshaper​

 

[dreamshaper]

Hey Deb,

Thanks for the quick reply. I tried that but I could still not make it work....perhaps I am doing something wrong and checked the main chandoo tutorials to find a solution but no luck...

 

[Somendra Misra]

@dreamshaper

Applying the formula in column L as per @Debraj suggestion, its working. When you copy formula remove the table name from the formula.

Regards,

 

[dreamshaper]

Hey Somendra
No luck, I try doing that and it effects the final sheet where it provides yearly total....

 

[Somendra Misra]

@dreamshaper

See the attached file.

Regards,

 

[dreamshaper]

Thanks a lot guys....I really appreciate it Btw is there a course for excel for finance professionals?

 

[Somendra Misra]

@dreamshaper
Welcome back anytime. There must be a course. Visit Chandoo.org/wp for course details or write to @r1c1 .

Regards,