Looking to have Excel propagate a row of cells via mouseclick on a single cell at TOP of s

By comparison to ALL of you I am ONLY an amateur user of Excel. I know how to write basic formulae but do NOT know how to create Macros. A long time ago, at ne of my previous employers, a co-worker of mine created a very simple but effective Excel Spreadsheet (using Excel 97) which we used as a call record which, in its simplicity enabled us to click on a single cell at the top left cell of the of the spreadsheet. It instantly (and almost magically) added in an entire row of cells across the top of the spreadsheet (each one labled with the specific parameters that we had for the row below it). In effect, it enabled the spreadsheet to display MOST RECENT to OLDEST call records from TOP to BOTTOM.

Do ANY of you experts out there know how this is done. (question mark). I have searched every forum on the Internet using every description I can think of but have found NOTŮHING describing this operation. Ičve found every subject BUT this one.... Please help me.... Thank you!


signed Stumped on Excel.

Hi
it would take a very simple macro to add a row at the top of the sheet and put text into the first few cells. For example, this macro adds a row at row 1 then inserts the labels "Label 1" through "Label 3" in columns 1 to 3

Sub AddRow()
Dim MyLabels As Variant, x As Long
MyLabels = Array("Label 1", "Label 2", "Label 3")
ActiveSheet.Rows(1).EntireRow.Insert
For x = LBound(MyLabels) To UBound(MyLabels)
    Cells(1, x + 1) = MyLabels(x)
Next x
End Sub

Is that what you want? Or, do you have something else in mind when you say "specific parameters" from the row below?