You can use these formulas
D13: =Q7
E13: =IFERROR(IF(D13+1>$S$7,"",D13+1),"")
Then copy E13 to the right as far as you need.
More Related Contents:
- Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
- Excel Number Separation [closed]
- Excel formula checklist in employees
- Error in finding last used cell in Excel with VBA
- Excel VBA – How to add dynamic array formula
- Filling any empty cells with the value above
- Find last used cell in Excel VBA
- Count unique values in Excel
- Concatenate column headers if value in rows below is non-blank
- How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
- Countif With Multiple OR Criteria
- How to extract text within a string of text
- How to roundup a number to the closest ten?
- Save excel file multiple times with file names in another workbook.
- Excel VBA, getting range from an inactive sheet
- Is there a way to crack the password on an Excel VBA Project?
- How do I declare a global variable in VBA?
- How to pause for specific amount of time? (Excel/VBA)
- VBA code doesn’t run when cell is changed by a formula
- Easiest way to loop through a filtered list with VBA?
- Parsing an ISO8601 date/time (including TimeZone) in Excel
- Getting the actual usedrange
- Delete a row in Excel VBA
- How can I run VBA code each time a cell gets its value changed by a formula?
- How to convert 32 bit VBA code into 64 bit VBA code
- Vlookup to copy color of a cell
- every possible combination of the contents of 2 columns in excel
- How to delete rows in Excel based on criteria using VBA?
- Macro to export MS Word tables to Excel sheets
- Delete all data rows from an Excel table (apart from the first)