Recent content by vijay.vizzu

Hi.. All :) I tried to write a query which can extract my data from Ms access database I have two tables namely dbo_users and dbo_SupplierUsers My question is : 1 ) I need to search SupplierCode in dbo_SupplierUsers, once it found it should return the UserCode (might be more than one user)...

Thank you .. all I will try to figure out...

Dear All Once again i need your expertise advise on the below issue I am new to Dashboards and i can create small graphs and other reports. I am very much familiar with Excel Formulas, Excel VBA and other MS office products. Now i got one problem that, one of my boss requested me to design a...

Dear Jayadev Can you please elaborate more about your requirement. If you want to learn offset formula, this site has so much stuff. Just search offset within this site, you will find more about offset along with some cool tips & tricks

Dear Deepak Thank you so much for your links. But I am very sorry to say this, I can't figure out the right way.

Hi..all I tried this to post in Outllook forums and searched a lot for getting solution. But I was unable to get the solution. So finally I decided to post this in this forum. If it is not compatible with this forum, then I request forum moderators to delete this post My problem was, daily...

If you can upload the file with the above formula. It can be easily explain the step by step for better understanding.

Dear ..Ramesh Please try this code.. and let me know the status. (Change code as per your requirement) Sub DataFilter_No_Due_Date() Dim wkb As Workbook Dim sWks As Worksheet Dim rWks As Worksheet Dim fltRng As Range Dim criRng As Range Set wkb = ActiveWorkbook...

Dear.. Ramesh You can achieve this by Advance filter method in Excel VBA.. Please search this forum, you will get it.. Meanwhile I am preparing code for you... :)

I just put round function in that formula =IF(COLUMN()-COLUMN($F:$F)<ROUND($D$4/$E$4,0),$E$4,"") Now its working.. if is there wrong in this .. then please let me know

Dear Narayank... But there is small problem.. If I put in cell D2 (Inventory Stock) as 500, and in cell E2 ( Daily Production Requirement) as 216, then it shows in three columns 216,216,216. But if we sum the qty, its around 648. So it gives error. It should display in only two cells instead...

You are awesome.. guru..:)

Please have a look on this http://chandoo.org/wp/2012/06/19/extract-numbers-from-text-excel/

It seems, you have one space between number and Character. So you can use Text To Columns option to make it. Numbers in one column and text in another column.. Please try

You can use Find & Replace option to get rid of this..