User Profile
Vinod2406
Brass Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Paste conditional formats
I am having a master file (Complex & large) hence I want to avoid conditional formats in the master file. Instead another sheet for performing all my conditional formats and paste conditional formats to the master sheet at the end of the day. Ok even if the conditional formats is part of master excel file. Any help pleaseRe: Calculate Time Difference exclude non-operating hours and holidays.
Since you are having different operating hours , it is advised to mention all the dates from start date to end data in a column . You can map week name using text(A2,"DDD") and mapping hours or can use IF condition to get hours automaticallyExcel freeze while removing filteres
I am using split screen option at office and while removing filters the screen is freeze state, unable to edit . while trying to close showing as below and need to select save option from experience where it ideally it will be. This issue happened with 2 reports , one very large file with VBA scripts and other is simple without any VBA . I am using windows 10 enterprise version and my laptop is i5 equipped with 16GB RAM . Any help please
