Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Become a Premium Member and unlock a new, free course in leading technologies each month.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Couple questions
Re 1)
â€¢What code ie what procedure ?
â€¢Why G7 till end ? your data starts at G3 shouldn't be G3 tlill end ?
Re 2)
Is this new procedure or existing procedure ? If Existing what is its name ?
Sub WriteFormulas(ByVal curRow As Integer, ByVal lastRow As Integer)
Range("H3:I10000").Clear
Range("H2").Select
Selection.Copy
Range("H" & curRow & ":H" & lastRow).Select
ActiveSheet.Paste
Range("I2").Select
Selection.Copy
Range("I" & curRow & ":I" & lastRow).Select
ActiveSheet.Paste
End Sub
ok fine, by part 2 you mean Hit formula Col I ??See heading in previous comment, there are two heading. Formula for GAP which is for solely Column H & Formula For Hit heading which for column I. Formula For Hit heading have 4 part. basically I had split the criteria.
I know and see you are also a quite knowledgeable expert in excel here so you knowing your stuff and explaining in detail the formulas do you believe the formulas are correct ? If you say so then I will be looking elsewhere.I am learning here so may be I am wrong on my part. but first look I dint find any thing wrong in my formula.
I also need to understand the ATR formula Col G why does it start at row 7 what should it calculate and how ? something here does not make sense. Do you need this column for the hit ?
if present day is higher then multiple of 7
01 H2>=H4 Current Gap (H Column Value) is Greater then or equal to forward 2 value (H Column Value)
hhhmmmm correct !! see I told you, your a pro in your business !!! :)
Deleting is not an option as when you do this with the kind of formula you have in Col G you get REF error in the 4 rows that are linked to the row that you delete.
My question for you: Are you sure the data is not correct ??? Remember when you ignore 1 row that says Ignore you actually have this row counted as a date but the values are not. You expected that all the other rows remain the same and not the red ones ???
Are you sure of the conclusion you made ? The only thing I am missing in my routine is that I did not modify the formula Evaluate(MIN ... and Evaluate(MAX ... maybe this one caused the error as when we exclude a row from a range we cannot use this same formula we need to adjust the formula so because it was long I preferred to give you the result first and then see. My feeling is that I need to modify this formula and then it will be fine.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.