Need help ( Excel sheet)

**azhar aali** · 31st May 2014, 05:06 PM

Dear All,
muje excel sheet k havly sey help chyea the. main apko explain karta hon aap help karin jis ko pata ho. humari excel ki sheet hai jo k hum monthly charges report banaty hain. month of may sey humary Rate change ho gy hain ab jo formula laga hova hai if main change karta hon rate new main tu jo pechly months ki reports hain wo sab change ho jati hain q k file ak he hai har month ki sheet allag hai only. ab koi asa formula hai k main lgao tu jo phaly k rates hain wo un sheets main change na hon and new main change hon?

**Ghayyasg** · 31st May 2014, 11:08 PM

Es ka easy solution deta hoon, agar pasand aye to please amal kijiye ga,

ek new sheet nayen, us me tmam products ke names likhain aur phir next columns me april ke rate likhian, next column me may k rates likhain, har month ki sheet ka rate k cell ko wo reffernce dain jo k us month ka hai, matlab agar may ki details hai, to uska reference may ke column walay rates ka dain, es me apko izafi kaam yeh karna hoga k har mah apko rates ka jo difference hai wo update karna hoga, agar rates change nahi hotay to aap previous moth ke rates aglay month me copy kar lain , pasand aanay par aagah zaroor kijiye ga

**azhar aali** · 1st June 2014, 09:11 AM

Ghayyasg said:

Es ka easy solution deta hoon, agar pasand aye to please amal kijiye ga,

ek new sheet nayen, us me tmam products ke names likhain aur phir next columns me april ke rate likhian, next column me may k rates likhain, har month ki sheet ka rate k cell ko wo reffernce dain jo k us month ka hai, matlab agar may ki details hai, to uska reference may ke column walay rates ka dain, es me apko izafi kaam yeh karna hoga k har mah apko rates ka jo difference hai wo update karna hoga, agar rates change nahi hotay to aap previous moth ke rates aglay month me copy kar lain , pasand aanay par aagah zaroor kijiye ga

hahah kafi mushkal kam bata dia apny