Search results

I have more than 300 sheets in a workbook. All sheets were working normally. All of a sudden Mouse scrolling in the first few sheets stopped working first 4 sheets out of 300 sheets scrolling are not working. Kindly advise Regards Narayan Govind

Thank you very much.

Dear All, Kindly advise the code to find the cells that are with the specified colour and then replace the Colour shade of a cell with the selected colour Example The Below code does the job of manually selecting the cells. How to automate the same with a code for a sheet without selecting any...

Thank you so much for your help

p45cal Thank you very much for your efforts and reply with an example If I provide input in any of the 2 cells and if I press the DELETE key in the required result cell then results are displayed If the same is automated like if the user KEYED IN any of the 2 cells the 3rd cell is to be deemed...

Dear All, Kindly refer to the below requirement. The user will enter input in any 2 of the cells. Based on those inputs from other cells 3rd cell will result as per the formula as listed. Is it possible to get this done In excel VBA? Kindly do the needful as necessary. Regards Narayan Govind

GraH - Guido Yes copy-pasting the curve works well Thank you

Hi it is only a representation Not the actual data Series 1, Series 2 Series 3 Series 4 all are having different data but follow same pattern for different person Here my request is how to make a chart in a easy way Create one series 1 Duplicate Series 1 to many that points to same data...

@vletm Kindly find attached the file for my case B and C column has the Series 1, similarly, i have series 2 in E/F, Series 3 in H/I, Series 4 in N/O Manually i have selected the range for Series 1 Series 1, 2, 3 and 4 (similarly i have 20 more) follow the SAME pattern as like Series 1 So i...

Thank you I understand that there is no programmatic way to handle this requirement as I have 10 set of such plots and I need to copy it to create another 10 set only by changing the data range

vletm Thank you for your resolution Kindly advise what version of this excel you are referring to. I'm using office 365 in windows 10 OS where I didn't see this option

Dear All, Kindly advise how to Duplicate a series within a chart I have a chart name Chart 1 with Series1 as one curve I need to Duplicate Series 1 with the same data range with the name as Series 2 in the same chart 1 Is there is any code that will do the above task Regards Narayan Govind

Yes it is from your inputs I was not aware of the hidden sheet it is created by another add-in now I found it because of your inputs I unhid from the sheet property Thank you once again

HI Found the solution From your TIPS Thanks a lot

Sorry Attached is the file without VBA password I have tried your code I haven't created the hidden sheet Please refer to the attached file

Vletm, I have already tried but it is not working In the attached sheet I used the code but not succeeded I really have no idea over the other sheets How to find them Suddenly this error appeared Please help

Reference files

Dear All, In my workbook which I was using for many years, ended with this error Simple code used in another new workbook is working well Both worksheets are attached for reference The workbook that shows error has to be rectified as it is my original workbook with other sheets deleted Kindly...

Dear All, Thank you for your support Attached is the file it is working for me well but there are issues in the display for 1no. or 2 number of days progress If the start and end date is more than 5 days it is working regards Narayan

Kindly advise any project planner available as a readymade solution to Plan the project start date, activity data, end date for one whole year in a Excel Sheet Regards Narayan Govind

Dear Belleke Attached is the example file Kindly advise Regards Govind

Please advise

Dear All, The below code is working well for a change in the cell value A1 as well as for a change in cell value C2. Change event needs to be triggered for a FORMULA result in the cell A1 and C2 not the direct entry edit in the cell A1 and C2 Please confirm this code can be used without any...

Perfectly working as well Thanks

GOT it by formatting the date as dd alone Thanks a lot