Recent content by mfaisal.ce

Dear, I wan to make a bar chart with below table BudgetActual SAP100.090.00 H210800.09000.00 but because the difference is high in SAP & H2 categories.... the Bar for SAP is very minimum. Is there any way to have different scales for SAP and H2 but on single graph...

Thanks a lot for your support regards,

Dear, Thanks for your replay. may be i cound not explain properly. I am attaching my reference file, Sheet "Summary". E4 has Budgeted value for whole week but this value remains same for whole week because it is calculated once and F4 value changes daily based on acutal value and progessively...

Dear, The above mentioned formula worked perfect as i highlighted earlier. Now, i have some new requirement in this formula. 1. Current formula gives me weekly production at once and that production is shown unless next week starts. My requirement is weekly production should not be shown at...

Dear, Thanks for the help. i tried but unable to succeed. can u plz check the file. Aim is to calculate Red colour values seperate and Black colour values seperate in a column. regards,

File attached

Dear, I have a file with multiple sheets more than 100. I want same formatting and page size in all Means i want to print all but there are many sheets which are printing empty sheets as shown below. i need format like below Can you please help in doing this formatting for all sheets at...

I have read on internet that Get.Cell(24,[cell_address]. it will give u color no . Is ther any way to use this function and then calcuate sum. Suppose, Column A has values with different Font colours. Column B will give colour no based on Font colour in Column A using Get.cell(24,[Cell...

Hello, Is it possible without VBA coding? means excel dont have any method to count cells based on colour? regards,

Dear, There is any issue in the link file that if you move the link file away then Excel chart in PPT file will not be updated. Is there any way by macro or vb that i just run the program and it updated the associated charts in PPT file instead of manually updating each time. regards, Faisal

Thanks a lot. It worked. regards,

Dear, I have a file with below Sheet Name:Dailywise Value in Column: AV Date in clumn: A there is another sheet name "Summary" in that sheet, for each month how to find the last non-empty cell value in Colum in AV from DailyWise Sheet where Date in Column A is matches with Date in Summary...

Thanks for your input.

Hello, I have excel charts in excel which are copied to an powerpoint file. How i can update the excel charts in power point file when i open it without manual update of each chart. Is there any possibility? Regards, Faisal

Thanks a lot. It worked. regards,