Parker
04-28-2009, 02:55 PM
I am new to all of this, and am just starting to learn my way around VBA. Please help me.
Where I work, I publish a workbook monthly that displays our equipment list and the dates that the last maintenance was performed on. We recently upgraded to a newer version of Maximo that will give me and excel spreadsheet with the equipment numbers and the dates that I need. I just need a simpler way of importing this data into my monthly workbook.
My spreadsheet that I get has the PMNUM and the completed dates in it, I get this information monthly, so I will only be inputting one month at a time. I need marches dates in the march column and lined up with their PMNUM row.
The PMNUM's are organized througout the whole workbook, so this is not limited to just this worksheet.
I cannot post links yet sorry.
:help
David
Where I work, I publish a workbook monthly that displays our equipment list and the dates that the last maintenance was performed on. We recently upgraded to a newer version of Maximo that will give me and excel spreadsheet with the equipment numbers and the dates that I need. I just need a simpler way of importing this data into my monthly workbook.
My spreadsheet that I get has the PMNUM and the completed dates in it, I get this information monthly, so I will only be inputting one month at a time. I need marches dates in the march column and lined up with their PMNUM row.
The PMNUM's are organized througout the whole workbook, so this is not limited to just this worksheet.
I cannot post links yet sorry.
:help
David