Hi Avinash, Not entirely getting your point. Please confirm if you need following < which I can understand per your post> :)
1) Following results as per Date in first field < this you have already attached> Date Total Product Actual Price Total Number Of Products Grand Total Sheet Location 2) Hyperlink in last field to each row entered ? I believe either you are explained too much in your post or missed to put the crux of your issue in lime light. :) Regards, DILIPandey On 1/27/12, Avinash Patil <avinash007pa...@gmail.com> wrote: > Hi Experts, > > > i am currently facing very serious problem cuz every day i have to generate > data from various workbooks wich is bassed on the daily reports. > > and i have to show any increase or decrease on any perticular day > > to get this done i have to insert 1 sheet called summary it contains > following details like day wise details. > > but to show the day wise performance i have to link specific cells > > > e.g > > sheet name jan 01 > > > total products = 06 (D14) > > so if the client wants to see performance for the specific day i have to > vlookup for the results > > and the lookup is bassed on summary sheet > > > plus if there there will be uncertain increase or decrease in the data i > have to create link for that specific day. > > but link should not be in hyperlink format it should b in normal format > but only highlited in red font. > > > and by the way i have to create summary sheet for my refrence not for client > > client want result only for specific day like for increase and decrease. > > client result is using red border. > > > i have attached the sheet for your refrence > > please see the attached file and kindly help me in this regards. > > > if possible can anyone please prepare a macro/formula to get the details > > -- > > Thanks and Regards, > > Avinash > > "Love does not happen its a choice. Its not magic or fate, but it is when a > person takes their natural affinity/attraction for someone and translates > it into commitment and actions that express love." > > > Disclaimer: The information transmitted is intended only for the person(s) > or entity to which it is addressed and may contain confidential and/or > privileged material. If you are not the intended recipient of this message > you are hereby notified that any use, review, retransmission, > dissemination, distribution, reproduction or any action taken in reliance > upon this message is prohibited. If you receive this in error, please > contact the sender > > -- > FORUM RULES (986+ 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. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com