Search results

Thanks all for your efforts, File i have posted above is working Fine at present, but my main dashboard is still having same issue. i dont know why in same system, excel files are behaving different, previous file is scrolling as per given parameter only but on attached file scroll bar on...

Hi All, I am preparing a dashboard where i have to link chart with scroll lock linked cell calculations, but scroll bar is not working properly. Once i am clicking on scroll bar it scrolls but does not stop if my pointer is on scroll bar. this is happening in both sitruation for Incremental...

Dears, i am adding shape thru my coding below is sample, but while declaring object use of "S" thing confuses me always. i.e. whether to use shape/shapes how could i identify this. Sub test() Dim sh As Shape Set sh = ThisWorkbook.ActiveSheet.Shapes.AddShape(msoShapePentagon, 5, 5, 5, 5) End...

Dear All, Today i face a new problem on my regular file which i use to compliing some files. while debugging the same i found Double Workbook object are created in project explorer. this is the code i am using Sub Compiler() Dim bookList As Workbook Dim mergeObj As Object, dirObj As Object...

Thanks Bosco, this function is working wonderfully. Strange thing is that I was not aware of this "SMALL function". Thanks alot Bosco once again

How could we get sorted unique date from unsorted date data in same sheets in two columns with formula? I have two columns which contains different dates but requirement is too make a graph which required both columns dates, in attached sheet yellow fill are input and pink filled is output and...

Yes, you are right it will done by something using collection & Array. But i am unable to do so. Hope any ninja will have a look on this,

@vletm Now in your File user will not be able to even select the red column cell but what i want user cant change it/or over write it. If you will see in my file you can edit in cell but with same value. My requirement fails when user re-edit/delete value in more than once cells Please help...

No there is some gap in understanding, actually in uploaded file Admin in Bhawani Patim (as per coding guidance) only bhawani patim could only edit in all columns data user other than bhawani patim is not permissible to edit under red columns (same is my requirement) but my requirement fails...

Hi All, I am working on a project, where some users update there data but intentionally or unintentionally they are overwriting it. Now overwriting the data creates mismatch in figures last report and current report. To avoid this i have attached sample file i am working on, which is...

Dear All, I am working on excel file where sheet1 is an input sheet, Sheet3 having existing records and sheet2 is a new master record of employee. In this user will updated in sheet1 columnA with some values and this value will be cross checked from sheet3, if value found then no action...

thanks you both, now firstly i will understand one of the function and will implement one of these. probably i will use difficult one ;)

if the Product_Godown_Status is fix (Column G) then out put in (Column I) should be equal to stock where Fixed_Product_Godown_ID is equal to Mall_ID AND maximum date against that product If the Product_Godown_Status is not fixed then maximum stock against that product_id How ever my attempt is...

How does it works and in which version this feature is available.

Hi, Follow this simple steps in attached images and try yourself

@ Jake collins - because it will save my time and mind both. simply it will take more time to type excel funcation with these manu funcations and also i was using same function you told me. so just to get rid of repeatative function typing:DD:DD:DD:DD:DD

@ Ramesh/Marc L = Ok thats right, checking vba auto quick info and inner help supported me. But my concern is little bit different, while random trying shortcuts for vba i found this by pressing F2 and searched for word Replace. so here if you will see there are below 3 things:- 1. Library 2...

Sorry i could not explain, but yes my excel is able to do the same. __________________________________________________________________ Mod edit : thread moved to appropriate forum !

i am trying to advance filter by date but it seems, that i am applying advance filter in a wrong method. enclosed is the attached file, please share any link tutorial if you have any for date criteria like date equal to or date less than or date between. please suggeest what should i do , or if...

Is there any possiblity of hiding columns, so that user could not hide it. actually i want to hide some history columns but in my morning meeting there are some chances of request for showing values of history columns temprory. now i am the admin of that excel file. pLease help

is it possible to activate the cell by user but not able to edit

Fortunately, i did a attempt but now in this case now i am not able to even stand on cell, and what if admin(I) want to edit that cell

Dear All, Please help me, i have a workbook with 57 user work on it on sharing mode with password protected workbook. name of workbook is DNE, is there any possibility if a cell has already a value than user should not be able to edit that cell, sheet length & height is cz8000. if in case it...

Thanks Luke for this simple tricky solution.

thanks for looking into my concern. yes please find attahced