Okay --
So I am a very new user to VBA and I am taking online lessons while trying to teach myself at the same time.
I have a db that tracks pricing data for multiple parts. Each month, on the 1st, I upload the new price for each part number, even if its the same as last months.
I want to create code that automates this process on the click of a button (or some other activation procedure).
I have a couple of ideas, but am unsure of what the code might look like as I am still very new to VBA.
The simplest idea I have, I think, would be to create a code module that copies all the data for a particular month, changes the date to the immediate next month, then appends the new data to the same table. This is preferable because most prices are relatively constant. If there were some changes, I could go in and change them individually.
Are there any experienced users here who can tackle a problem such as this one?
Any guidance and insight offered is appreciated.
Thanks,
-Brian