Search results

Hi , In that case , we can have a Data Validation set up in cell D1 , so that the user only has to select the required value. Having a button whose caption is long will make the button either long or big to accommodate all of the text. If you can upload the workbook with the 4 values in the...

Hi , I have done exactly the same thing ; instead of having 4 buttons for the four values in the PIC field , I have only one button , and the value you want to filter on is entered in cell D1. The advantage of this approach is that nothing needs to be changed even if you add another 10 values...

Hi , See the attached file. Enter A , B , C or D in cell D1 and then click the button ; all the tables will be filtered on the selected PIC value. Clear the cell D1 and click the button to remove the autofilter on all the tables. Narayan

Hi , Will the start and end dates always be the beginning of the month i.e. will the capitalization period always be a whole number of months , or can there be a fractional part of a month also ? Narayan

Hi , I suggest you check this out : https://chandoo.org/wp/download-expense-trackers/ Narayan

Hi , Let us leave aside the issue of the input data format. Assuming that the required data is all available in the worksheet , what kind of outputs do you want ? Narayan

Hi , Something like this ? Narayan

Hi , Surely what is relevant is the date , and if you can enter the date , the individual detail and the amount , with one item per row , that will make it easier to club entries together without the need for any merging of cells. A simple SUMIF based on the date will club together all entries...

Hi , The first MATCH function will return 1 if it finds a match in the first column ; so will the second MATCH function ; when we add these two results , we will get 2 , which is not the correct result. Of course here the second row of headers , row #3 , repeats the same values thrice , which...

Hi , One of the answers given in Excelforum pertains to a software called Evil Clippy. Please find out from the person who has posted that answer whether the software is the same as what is being discussed in this link ...

Hi , Enter this in cell C7 ; copy across and down. =SUMIFS(INDEX(Sheet1!$C$4:$Q$23, ,MATCH($B$3, Sheet1!$C$2:$Q$2, 0) + MATCH(G$6, Sheet1!$C$3:$Q$3, 0) - 1), Sheet1!$B$4:$B$23,$B7) Narayan

Hi , When I run the code in the workbook you uploaded , it aborts on Runtime error 9. Subscript out of range The offending line of code is : ReDim results(1 To titles.Length, 1 To UBound(headers) + 1) and when I check through Debug , titles.Length shows 0. I am sorry but there is nothing...

Hi , Have you tried it with this link ? https://www.amazon.in/s?k=kuki+fashion&ref=nb_sb_noss_2 Narayan

Hi , Can you upload a workbook with this code and the output in it ? Narayan

Hi , Does the code work with the second link you posted ? Can you ensure it works and then post the working code ? If you see my code , I am not using the Click method to click on any image. Narayan

Hi , See if this is OK. Narayan

Hi , See the attached file. Narayan

Hi , When I do it , I am not getting the results you get. Narayan

Hi , Wouldn't this work then ? =Table1[@Quantity]/COUNT($I$1:$T$1) Enter this in cell I3 , copy across and down. Narayan

Hi , In the workbook I have it doesn't. Narayan

Hi , There was a problem with the text Any in one of the dropdown selections ; it was not the three letters A , n and y ; it also had a trailing space , which is why nothing was being displayed. See the attached file. Narayan

Hi , It is not clear what the output should be like. The sum total of the past 3 years is 240 ; but was it 80 , 80 and 80 in each of these 3 years ? What is the purpose of columns C through H in your table ? Narayan

Hi , See the attached file. Narayan

Hi , If all the computers are on a network , then anyone can access the file , just as if it were on their computer. What is the problem ? Narayan

Hi , See if this answers your question. If it does not , please upload your workbook. https://chandoo.org/forum/threads/filter-multiple-tables-at-once.1684/ Narayan