I have not had much experience writing SQL code, I as taught VBA code in school, but not SQL. At least in Access it seems to be different but less involved. 58 more words
Tags » Vba
A handy code snippet for merging two rows of data!
Sub Macro1() ActiveCell.Offset(1, 0).EntireRow.Copy ActiveCell.EntireRow.PasteSpecial Operation:=xlNone, SkipBlanks:=True, Transpose:=False Application.CutCopyMode = False ActiveCell.Offset(1, 0).EntireRow.Delete (xlShiftUp) End Sub … 43 more words