I would like to automate the daily insertion of information into a worksheet

The easiest thing to begin with is to record the macro. Go to the developer tab (not visible? visit https://msdn.microsoft.com/nl-nl/library/bb608625.aspx) and press the "Record Macro" button. This Macro is probably very messy and maybe not working on other files, but it will provide some starting point

Thanks. I tried that and recorded the information being entered, but when I ran it it must have reentered the information on the same line. I need to enter the same info on the next row each day.

OK, I have recorded a macro and have it working to insert the information. However, I used the copy and Insert Copied Cells by means of a button. It enters the information , but it puts it on the same row every time(shifting any further entries down by 1 row). How do I make it go to the next empty row to insert the information? Here is the Macro code so far:

Sub Insert()
'
' Insert Macro
'

'
Rows("1:1").Select
Selection.Copy
Sheets("RAMP Log").Select
Rows("138:138").Select
Range("B138").Activate
Selection.Insert Shift:=xlDown
Sheets("Davids Macro").Select
Range("A3").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = ""
Range("A1").Select
End Sub

Oke, if i interpret your Macro correct, you want to Cut row 1 from a certain active sheet and copy it to sheet "RAMP Log". Is the original data is on sheet "Davids Macro"?

Try this:

Please Login or Register  to view this content.

What is does:

First determine the last row in the sheet where the data needs to be cut into (RAMP Log) and add 1 to it so the last row is an empty row.
Note: it searches for the last row in which column A has a value. If A is not always filled, you will get into trouble (you can alter the "A" into "B" ofcourse when colum B is always filled)
Then it cuts row 1 from Davids Macro (source sheet) to the RAMP Log sheet.

I'm not sure if this is all what you intended to do, it looked like the only functional code in your macro. I guess you 'accidentally' activated some other sheet again without doing something.

If the source is not always on the first row, but also on a last row or whatever, the macro will change Range("1:1") will be dynamic, just like I've done with the LastRow variable.

You are correct except that I don't want to cut the data from Davids Macro, I want to copy it to the next empty row on the RAMP Log. Question, is this a macro or is this VB code that I could attach to a button?

If you don't want to cut it, just change .Cut to .Copy.
Also, those are one and the same. Macros are a name for VB code procedures, and you can attach them to a button if you wish to do so.

Originally Posted by krhoover

You are correct except that I don't want to cut the data from Davids Macro, I want to copy it to the next empty row on the RAMP Log. Question, is this a macro or is this VB code that I could attach to a button?

A macro is vb code. If you want to attach the code to a button, just follow this guide https://support.office.com/en-us/article/Add-a-button-and-assign-a-macro-to-it-0d07db65-6e97-41a0-8396-4db6aef7b3bb

I think I have corrected the errors pointed to. Please let me know if I need to make additional changes.

I figured it out and it was on my end. Thanks for all your help!!