Search results

Hi P45cal, Even I think so, but thought to check here before conclude to it. Regards, JD

Hi Guys, I just want to know is there any option available in Excel to remove filters from multiple sheets in a active workbook without VBA code. Regards, JD

HI Guys, I mistakenly post my query under data visualization section of the forum - https://chandoo.org/forum/threads/i-need-help-to-forecasting-on-my-powerbi-report.43044/ Appreciate your help on the aforementioned thread. Regards, JD

HI Experts, I need help to make forecasting option enable in my attached power BI file. I researched online and it says the value in the X-axes should be in proper date format for the option to be enable under visualization option. I am not sure what I am doing wrong and need your assistance to...

Hi Guys, I know this is not a right place to post this query. I just want to know do we have forum for BI query. Regards, JD

Hi Chihiro, Thanks for the code and it fits my need! Regards, JD

Thanks everyone! I am dealing with a situation where .csv and .xls files are saved in a common folder or location. What I am looking for is to open each file with VBA and perform set of operations and save it with .xlsx extension. Regards, JD

Hi Experts, I am not sure if this is possible or not?. Is it possible to read/open different format of files (TXT,CSV,XLS) from a directory/drive. Regards, JD

Hi p45cal and Chihiro, Thanks for the above information and code. This is really helpful. Appreciated your input on this! Regards, JD

Hi Experts, Please let me know if this is possible or not. I have a sheet which contains red cell with both Manual and Conditional Formatting red colored cell. I want to count the number of cells with both options available in the sheet. In the attached sample column A is the manually added...

Hi Experts, I am stuck and need your assistance to get this fixed. I need to find the list of words available in the reference sheet tab attached in the thread from the Column A (RAW Data) of data sheet/tab. Once the word is find in the Column A it should be placed in the respective column in...

Hi Experts, I need your help in this. I want to fine a column says Sample3, N as per the attached sample in sheet1. Once it find the respective column, remove “, N” from the column header and add the letter N with the data in the entire column Sample3. Please refer the output sheet for better...

Hi Experts, Could you please help me with the formula to know the day before a given date. Ex - 01-march-2013 should be 28-Feb-2013 31-May-2010 should be 30-May-2010 Regards, Jagdev

Hi Experts, Is there any way or formula with which I can convert any number value to figure without vba. ex 1 to one 11 to Eleven etc.. Regards JD

Hi Marc, Thanks for the code and it works like a charm! Really appreciate your input on it. Regards, Jagdev

hi, sorry for not filling in dummy data. I left for the day. will upload the sample copy again tomorrow. Regards JD

Hi Somendra, my data in both the sheets are different The header names are common. I want to re-arrange my data with header name as per the header sequence in sheet 1. please let me know if I m still unclear. Regards, JD

Hi Experts, Please provide me a way to deal with this issue via VBA. I have data in sheet1 and sheet2. I want to re-arrange the headers in sheet2 as per the order in sheet1. Regards, JD

Hi Ashwin, Please check this link. It should guide you to a direction. http://excel-macro.tutorialhorizon.com/vba-excel-find-a-word-in-a-specific-paragraph-and-change-its-formatting/ Regards, JD

Hi All, Thanks for your input on this. I tested Jindon and Narayan Sir's option and it worked well. Again thanks folks for providing varies input on this. Regards, JD

Hi Experts, Is there any easier way to get rid of additional space available in the headers of the attached sheet. Regards, JD

Thanks Again Deepak for the above code! You are a champ and genius! Regards, JD

Hi Experts, Any views on the below amendments. Regards JD

Hi Experts, I need your help to deal with the above request further. I have attached a copy of the template and data in separate tab. The vba code to run and create a separate copy filling the information available in a separate tab in the sheet named "Table" and saved the copies in a folder...

Hi All, All the formulas are effective and fulfill my need. Thanks folks!!!