Search results

Dear Francilla Thanks again for staying with us. I have investigated the workbook you provided. In sheet1, I have calculated the median for 2018, 2019 and 2020. Through the following sheets, I highlighted with green color where you were doing correct or wrong calculations. I have implemented...

Dear Francilla Sorry for the late reply. Currently, I am going through the issue you have mentioned. I will share the solution in this thread as soon as I solve the problem. Good luck! Regards Lutfor Rahman Shimanto

You are most welcome, Stefan. Regards Lutfor Rahman Shimanto

Hello Stefan Thanks for bringing the issue to ExcelDemy Forum. I have analyzed the formula you have provided. The formula calculates the date of a specific day in a month. You must provide a date, week, and nth day as inputs. You need three distinct inputs to use this formula. Moreover, you are...

Hello Craige Harper Thanks for posting your query. You want to change the color of a particular text in a cell. We can easily do this by selecting the text and changing its color. Assuming you will do this a lot of time for various cell texts. In this case, you can use the Excel VBA code. I will...

Dear Gredang As SharePoint itself is a web-based collaboration platform, it does not allow the use of VBA macros within its interface. I am sorry for your frustration. You can create a Form using PowerApp. Later, enter the data into SharePoint from PowerApp. Connect an External Excel file with...

Greetings from ExcelDemy Forum. You are most welcome! Francilla.

Hello Gredang It is great to see you again. Previously, you asked for an Entry Form with buttons like Generate, Next, Previous, Delete and Print. You have said that Office SharePoint does not allow you to use a macro. Thus, you want similar features described previously but not to apply any VBA...

Hello Francilla Thanks for reaching out and posting your query. You wanted to calculate the median age group for a grouped dataset. I am delighted to inform you that I have solved your mentioned problem. I will introduce you to a mini calculator regarding your issue with error handling. When...

Dear KENNY H The procedure you applied in the generation of barcodes is excellent. Assuming you are using mentioned user-defined function implemented in VBA. However, I can give you an event procedure to improve your method. This event procedure will format the cell to Code 128 when you call...

Hello KENNY H Thanks for reaching out and posting your issue in Excel Forum. You described that your generated barcode does not work. You also mentioned it does not 100% match the master barcode. Assuming the ZEBRA printed barcode is the master barcode. I have scanned the ZEBRA printed barcode...

Hello Gredang Thanks for posting your issues in ExcelDemy Forum. The requirement you mentioned can be implemented by using an event procedure. I have reviewed your Workbook and developed an event to achieve your goal. Excel VBA Event Procedure: Private Sub Worksheet_SelectionChange(ByVal...

Event for GPEntryForm: Private Sub Worksheet_Change(ByVal Target As Range) Dim wsEntryForm As Worksheet Dim wsResult As Worksheet Dim lastRow As Long Dim countValue As Long Set wsEntryForm = ThisWorkbook.Sheets("GPEntryForm") Set wsResult = ThisWorkbook.Sheets("GPResult")...

Macro for Print: Sub PrintUsedRange() Dim ws As Worksheet Dim usedRange As Range Set ws = ThisWorkbook.Sheets("GPForm") Set usedRange = ws.Range("A1:L46") usedRange.PrintOut ws.Range("B2").ClearContents ws.Range("B14").ClearContents...

Macro for Delete: Sub DeleteRecord() Dim ws, wsEntry As Worksheet Dim rng As Range Dim temp, Target As Long Set ws = ThisWorkbook.Sheets("GPResult") Set wsEntry = ThisWorkbook.Sheets("GPEntryForm") temp = wsEntry.Range("A24").Value Target = temp + 5 ws.Activate...

Hello Gredang I am delighted to inform you that I have implemented all the necessary procedures. All you have to do is to assign the intended macros to the buttons. Additionally, I have developed two event procedures for sheet GPEntryForm. Macro for Save Record: Sub StoreDataInGPResult()...

Hello Gredang Thanks for reaching out and posting your requirements with such clarity. Your goal can be fulfilled by implementing some sub-procedure—for Example, procedures for Generate, Save Record, Previous and Next Record buttons. Later, you must assign these macros to the intended buttons...

Hello Gredang Sorry for the late reply. I was unavailable on that day for personal reasons. I hope you have found a solution from Seemanto Saha's reply. Thanks for staying with ExcelDemy Forum. Regards Lutfor Rahman Shimanto

You are most welcome, Mathi. Regards

Dear Mathi Thanks for reaching out again. Your described issue can be solved using a formula and the Conditional Formatting feature. Steps: Choose cell B6 >> insert the following formula >> drag the Fill Handle icon to G6. Later, select range B6:G6 >> go to Home >> click on Conditional...