$$Excel-Macros$$ Re: Help needed enclosed template also
Hi mandeep. I have to compare prices of different varieties in various markets across markets. Mostly the price comparison is on daily/weekly/Monthly/Yearly basis and thier absolute change or diffrence between two dates. But in the above formula mentioned by you,i have to select dates for various reports and to compare the different dates but in this i have to change the formula daily. And also to keep out the market or variety whom price are not available for the two dates. Is there any permanent way ,any coding or any other way. On Tuesday, November 18, 2014 10:41:27 AM UTC+5:30, Mandeep Baluja wrote: > > Create a calculated field and set the format of text according find the > result attachment. > > Thanks > *Mandeep baluja <http://vbaexcelsql.blogspot.in/>* > > On Monday, November 17, 2014 2:11:34 PM UTC+5:30, ram gopal yadav wrote: >> >> 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.
$$Excel-Macros$$ Help needed enclosed template also
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
$$Excel-Macros$$ Re: need guidance in learning macros and VBA
Hi all, Thanks Prince, Rajan, Ashish You guys really shared wonderful info... As of now i m start reading the book and source on net. *BUT, is there any way to learn it by seeing video-Tutorials and yes is there any kind of certification xam for the same which would be useful for my Job prospects.* * * *And i m very much thankful to u if u can suggest me someone in delhi who taught the course or some online mentor.* Thanks Again On Sunday, 23 September 2012 09:57:47 UTC+5:30, ram gopal yadav wrote: > > Hi all, > > Please tell me the books or video links useful for learning macros and > VBA. > > Looking for valuable advice. Thanks in advance. > > > Regards. > > RAM GOPAL YADAV > Mobile No's:- 08130155401, > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: Introduce Yourself !!
Ram Gopal Yadav Research Analyst-Agri Commodities Noida New to VBA -- need help how to start i.e, from basic Hope i will be learn VBA.. On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest online community of excel Fans! > > I hope you enjoy your time here & find this forum to be a friendly and > knowledgeable community. Please feel free to post a small introduction, a > friendly hello or tell us a bit about yourself. Why not tell us where are > you from, what you do, what your interests are, how old you are, which is > your favourite excel site or blog is or anything else that comes to mind! > > Thanks for your time > Ayush Jain > Group Manager > Microsoft MVP > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ need guidance in learning macros and VBA
Hi all, Please tell me the books or video links useful for learning macros and VBA. Looking for valuable advice. Thanks in advance. Regards. RAM GOPAL YADAV Mobile No's:- 08130155401, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Help in Learn advanced excel in noida
Hi all, Kindly tell me that from where i can learn advanced excel in noida(U.P). please tell me the best institute/faculty in noida from where i can lear macro and VBA Thanks in advance. Ram Gopal 8130155401 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
