Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Sub ClearMeasuringUp() If MsgBox("You are about to clear the entire worksheet - Are you sure you want to proceed?", vbYesNo) = vbYes Then ActiveSheet.Range("B28:D28,F28:H28,J28:L28,P28").ClearContents ActiveSheet.Cells(27, 14).Value = "Diameter" Application.Goto Reference:="Diameter" Selection.ClearContents End If End Sub
ActiveSheet.Cells(27, 14).Value = "Diameter"
|Find reord based on ID, specific date of service in a range and specific comment. If match then indicate in master file yes or no||12||24|
|Consolidate multiple worksheets from different workbooks into single sheet where columns are differently structured||2||28|
|VBA copy column paste as value||5||20|
|Excel fill in a form with pick list or drop downs, also need calendar pick||25||22|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!