Eforexcel.com Website Review

Need a data validation formula for following as*uming you are putting data validation in cell A2. The user should be able to enter a date in following format If your sheet has plenty of formula and you want to convert them into Absolute references i.e. One way is that you convert each one of them individually or use some logic for Find and Replace. But all these methods have their own 1. Make a backup of your workbook. 2. Open your workbook and ALT+F11 3. Locate your Workbook name in Project Explorer Window 4. Right click on your workbook name > Insert > Module 5. Copy paste the Macro code given 6. Go back to your Workbook and ALT+F8 to display Macro Window 7. Run your Macro from here 8. Delete you Macro if the Macro was needed to be run only once. 9. Otherwise save your file as .xlsm if you intend to reuse Macro again. Sub ConvertToAbsolute() Dim Rng As Range, Cell As Range Dim Ws As Worksheet Set Ws = ActiveSheet Set Rng = Cells.SpecialCells(xlFormulas) For Each Cell In Rng Cell.Formula = Application.ConvertFormula(Cell.Formula, xlA1, xlA1, xlAbsolute) Next Sub ConvertToAbsolute()     Dim Rng As Range, Cell As Range     Set Rng = Cells.SpecialCells(xlFormulas)     For Each Cell In Rng         Cell.Formula = Application.ConvertFormula(Cell.Formula, xlA1, xlA1, xlAbsolute) Below is a possible solution to CHALLENGE 69 - NEED HELP IN NOT SHOWING COMMENTS Select the cell where pop up message is appearing > Data tab > Data Validation > The pop message is in the Input Message > Either you can To remove them in block - 1. Select rows 1 to 7 > Data tab > Data Validation > Clear All 2. Select rows 20 to 22 > Data tab > Data Validation > Clear All Do*nload the workbook. Whenever I select a cell, the yellow box pops up. I need your help to provide me instructions to remove these. Below is a possible solution to the problem CHALLENGE 67 - GENERATE A PARTICULAR SEQUENCE =SUBSTITUTE(ADDRESS(1,3,4),1,) where 3 is for column C. So, we need to vary this 3.