Problems with copy and paste working with a command button.

I do not know which is the source sheet so I used active sheet. You can change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Alright, the code works the first time, but on the second, third, and fourth time the code is run, it does not carry the date in correct format.

I am also having trouble assigning the code to the button. My button keeps referring back to the old code after I clear it out and insert the new one.

"It does not carry the date in correct format".
Which one is the source sheet?
The code copies .Range("A3:H3").
Which one is next or what is next?
Where is the button so I can attach it to the code once we got the correct code?

The source sheet for the data is sheet1. It copies the info to the history sheet. The button is in I3 and moving all the data from it's left. I was able to get the code into it. When I right clicked it, I just assigned the macro to it.

Is there a way to deselect the copy highlight automatically after the code has been run?

If you want to copy all rows

Please Login or Register  to view this content.

It is working, but it still is showing a number value (41465) for the date in the second, third, fourth, etc. rows. On the first run, it puts the date correctly, though.

It is formatting issue.

Us this line

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Okay, it works perfectly except I only needed to copy row 3 when the button was pushed.

Please Login or Register  to view this content.

Thank you very much. I am just beginning to try and learn vba. I always pick it up quicker if I jump right in, but I'm struggling with even some of the basics. If you recommend anything for me to read on the web or a book to purchase, I'd be more than happy to. I have been watching quite a few you.tube videos, but most of them don't cover anything like an active inventory sheet of this manner.

This link is a good start.
http://www.excelforum.com/excel-prog...materials.html.
I was in your shoes about a year or so ago. I bought some books, but did not make much progress. Watching you tube did help me lots. Different people have different ways of learning and not two individuals are alike.
The best way to learn is by "Doing". "Practice", Practice, and Practice".
You are in the right forum.