expert

Hello, my UNIQUE, FILTER formula is pulling through results but autofit row height is refusing to work. I have selected all cells and used autofit row height and applied wrap text but it is not working. I have to re-select and apply these every time the formula pulls through a new result...

Hi I can't XL2BB as my work won't allow it: I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then...

Hello, I have the below assigned to filter buttons which automatically filter a list, based on the criterial. For "office" I also need it to filter "call centre" in addition. So when the "office" button is pressed, it also filters call centre with office. Sub Office() ' ' Office Macro ' '...

Hey There is there a way I can create something similar to the outlook Calendar input form that I can use for budgeting analysis on my excel spreadsheet? Is it crazy hard? Would this need to be done with User forms? Is there an alternate method you would suggest? Thanks in advance! Kind...

Please help me that how can we repeat column B names (vamsi and suresh) until cell value = EOH12 (column A). A column I B column E0H11 vamsi E0H24 suresh E0H01 (Repeat here) E0H54 (Repeat here) EOH12 (Repeat...

Hi I am trying to work out the above error on the attached workbook and have spent hours but to no avail. ContentsSheet.Protect DrawingObjects:=True, Contents:=False, Scenarios:=True Could someone please point me in the right direction as I am no expert in VBA and I have been given this task...

Dear All I have two sheets with some information on skill level of a team and with year of experience. Machine_A sheet is summary of no. of skilled person. Machine_D is sheet of data base. Let us assume i have 10 expert engineer in machine installation category. Machine_A sheet shows no. 10...

Hi, Expert I am new in a Excel. I went to get you expert solution for creating VBA on DTPicker Tool. When is used a DTPicker in a UserForm then showing creating date but i went to show hear as current date & to be change if required manual. I do not do it. Can any one please help me to solve...

Hi, Expert I am new in a Excel. I went to get you expert solution for creating a VBA code for Auto Filtering System. How Can I do it. Thanks in advanced.

Hi I was talking to a director of a company and he said they are looking for someone can do Financial Modeling in Excel/VBA and can train others with Financial modeling. I tried to google it and found many links but they are all gear it to Finance. I would love to hear "what is financial...

Hello all, Good day. I have 200 Folders . each have more than 1 files are there . ( Excel or PPT or PDF etc file ). I Need to insert object file in the excel file. If there is any way to do this in bulk? Please help. Regards

Hi Expert, I wan to get a result from numeric to word with formula without macro, can any expert help me to do this e.g 1293801 to be ' twelve Million nine thousand thirty eight handed and one only Thanks in advance

Hi all, First time poster - would appreciate your help. I'm comfortable with using Excel but I would like to commit more time into learning it from first principles. Could someone guide me to a syllabus for - Basic - Intermediate - Expert. I know there is a MS Specialist Certificate but...

Dear all, Feel thankful to find this forum. I'm not an excel expert, nor a math expert. But recently I have to find the X value with this equation: Y = 0.0000302307X^6 - 0.0017620175X^5 + 0.0376232469X^4 - 0.3880372117X^3 + 2.3962783035X^2 - 3.6979108034X + 1.4580209629 I have a series of Y...

Hello All, So I joined this forum back in 2016 and since then have learned SO MUCH INFORMATION that has helped me and now I am able to help others that were lie me before i joined here. It has been an awesome ride and I really enjoy it. With that being said I have been thinking about making a...

Hi, This might be a stupid question but I'm not an expert (yet) in Excel formulas. I have used the following formula: =SUMIF(A:A,A:A<TODAY(),B:B) In my column A, I have only dates and in my column B numbers. I tried a simple IF to compare A with TODAY() and this works perfectly. I have also...

I have a few questions for those who use Excel in a professional environment or those who consider themselves Excel proficient. Why do you consider yourself to be an Excel expert? How do you keep up with the latest developments in Excel? How do you find if something new is going on in Excel?

Dear, when I open the excel file, the number sometime changed automatically to currency, could you expert please to help out? thanks. Best regards, Valley

Hi Everyone, I'm working on a Rent Roll for a Real Estate Underwriting Model. In included growth rates in my model, which have different start dates depending on when a lease is rolling over. Since I'm multiplying my base rent with a rate and want to increase the base rent with the same growth...

Hi, in case anybody should have wondered how to make use of named formulas: bit.ly/namedformula :) Cheers Vince