Dear friends,
Please suggest me a correction in this macro to achieve require output.
Sheets("LC").Range("G7").Select
ActiveCell.FormulaR1C1 = "1" ‘Here I want to enter the any register number of student and hid enter key
Sheets("LC").Range("A8").Select ‘Here I want to hid enter key and then a formula should be enter on ‘Register’ sheet in cell AA6 as follows
Selection.FormulaR1C1 = _
"=LC!R[1]C[-26]&CHAR(10)&TEXT(LC!R[21]C[-25], ""dd/mm/yyyy hh:mm AM/PM"")"
Formula = Value ‘It’s very important because the date and time is continuously changing in cell b28 on LC sheet
End Sub
Requirements:
I want to know how many times and when the student has taken LC. The date and time should be on register sheet from column ‘AA:AE’ respectively for each student.
The register number is a unique id for each student.
I want to hid enter key on cell ‘g7 and after a8’ on LC sheet. It is very important to hid enter key on a8 because after hiding the enter key the receipt number change automatically. Though the register number of a student is same but the receipt number for each receipt is different for each time.
I want the date and time of lc given infront of each student respectively.
Any help will be appreciated to achieve this target.
Thanking you in anticipation.
Bookmarks