VB Code to create historical log of current values

[N242NY]

Hello,
I have been working on a huge project recording health of systems.
I have created a simple sample of where I am stuck.

I am trying to get the values from my "HealthDataSheet" to be logged on the "HISTORYLOG" sheet when the user pushes a button located on the "HISTORYLOG" sheet. I would like it to move to the end of the list and create a new line with the current data.

As you can see I have started the code for the button, but I can't seem to figure out why it is not allowing it to work.

I also have list setup for each column on the HISTORYLOG (Tier0Hist, Tier1Hist), ect...)

If someone could look at this and give me a clue as to where I made my mistake it would help.

Thanks,

[ncmay]

I put some new code below yours and assigned the update button to the new macro.
See if this does what you want.

[N242NY]

ncmay, thank you very much for making the changes. It is working just as I was looking to do. You have taken my headache away.