Hi Sotiris You can give this a try. Hope this helps. Sunny
Hi Lea Can you attach your data and the expected results (with some explanation)? It would be easier to understand what you actually wanted.
Hi Lea I noticed that there are difference in the Month between Table1 and Table2. Example: Chana have months June-August in Table1 but April-June...
My guess is both cell A2 and B2 are blanks and that is why the result is showing 3/30/00 i.e. 03/30/1900 (US date format) You can use this formula ...
Hi Suzzietoo Assuming 10/4/16 is in cell A2 and (B) is in cell B2 then in cell C2 you can enter: =IF(B2<>"",B2+90,A2+90) Hope this help...
Hi Dritan You can give this macro a try. I have changed the file type to xlsm. It will extract the data to the Output worksheet. Hope this he...
Hi Frans If you want to sum all columns and rows in one-go, just select the data plus one extra column to the right and one extra row to the bottom...
See if this is what you wanted.
Please refer my answer to your previous post : how to copy data from same cell from multiple worksheets within same workbook to separate cells with...
Since your sheets name contains more than one word, the formulas need to be modified a bit to include single quotes with the file name. Refer attac...
Hi Frans You can select cell N47 (where the subtotal is) and drag the little black dot (at the bottom-right corner of the cell) to the other column...
Hi Dritan You may not see it, possibly it could be a custom function that is not available in Excel 2010. That is why it is giving a #NAME? error i...
Hi Melanie I assume you want to enter a name expect Data Validation list to show all names that contains the text AL (for example) such as ALEX,ALL...
Hi Kaye Are you trying to summarize the values from multiple sheets based on the sheet's name in a cell? Maybe you can see if this is what you w...
Hi Mélo No idea what you mean by an "appealing" tracker. I assume you mean more colours/images/charts/data validations/alerts etc. Maybe the att...