Hey guys.
I have a spreadsheet that fills down from a UserForm when info inputted.
I have a column for each date - is there a way to get Excel to populate the desired column dependant on the date
At the moment I have
[VBA]Range("C3").Select
ActiveCell.Value = TextBox1.Value
ActiveCell.Offset(1, 0) = TextBox2.Value
ActiveCell.Offset(2, 0) = TextBox3.Value
ActiveCell.Offset(3, 0) = TextBox4.Value
ActiveCell.Offset(4, 0) = TextBox5.Value
ActiveCell.Offset(5, 0) = TextBox6.Value
ActiveCell.Offset(6, 0) = TextBox7.Value
ActiveCell.Offset(7, 0) = TextBox8.Value
ActiveCell.Offset(8, 0) = TextBox9.Value
ActiveCell.Offset(9, 0) = TextBox10.Value
ActiveCell.Offset(10, 0) = TextBox11.Value
ActiveCell.Offset(11, 0) = TextBox12.Value
ActiveCell.Offset(12, 0) = TextBox13.Value
ActiveCell.Offset(13, 0) = TextBox14.Value
[/VBA] etc etc which populates down from C3 but I want it to look first and find the date in Row 2 and if it matches todays date fill down from there.
In C2 I have the date say 17/01/08 in D2 its 18/01/08
Can upload spreadsheet if needed.
Thanks for your help