Hi, so my data has kids who are being billed "Weekly", "Monthly", and "Bi-monthly". It is dynamic data keeps on changing.
The problem is that On alternate weeks the data that needs to be pulled keeps on changing accordingly to their billing status.
If I put "Y" in the inputbox it takes a yes for the second string as well i.e it pulls the monthly kids as well.
here is the code so far: -
![]()
Dim answer As String answer = InputBox("Do you want to take the Bi-monthly kids? Y/N") If answer = "N" Then 'take only the weekly kids End If If answer = "Y" Then 'take both the weekly and the bi-monthly kids End If Range("A" & Rows.Count).End(xlUp).Offset(1).Select Dim answer2 As String answer2 = InputBox("Do you want to the monthly kids aswell? Y/N") If answer = "Y" Then 'take the weekly, bi-monthly and monthly kids as well If answer = "N" Then Exit Sub End If
Bookmarks