Dear all, i need your help in attached excel. In Worksheet named 'Master' - Daily prices are hand filled from various weblinks and sources.
In 2nd worksheet named 'pivot'- i get table from "master sheet" for variety prices in different markets. Here the blanks remain blank In 3 rd worksheet named daily- It is the output report to be paste in word file. Here i have to find changes and also delete the markets or variety whom last two day prices arenot available. Problem are I have to do daily removal of markets whom both day price are not available second,if a single day price is available change came as huge by considering blank as zero , so i have to do manually the Daily removal of markets whom both day prices are not available and also write NA (not available) in the price column whom one day price is available. Is it, any way where i can calculate the change in pivot itself and hide the blank automatically. Please find the enclosed template file Looking forward for your response asap. Regards. RAM GOPAL YADAV Contact-08130155401 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
template for prices.xlsx
Description: MS-Excel 2007 spreadsheet