Hi friends,

I'm quite the Excel noob but I'm working on a project that has 2 separate workbooks. One workbook is the project register, which has a list of all the projects the company has worked on by country name as well as project name and city name within that country. The second workbook is a cost database which is almost identical to the register, in that it has the country name, project name and city in the same order as the project register. The cost database also contains hyperlinks to different folders on the network with cost information specific to the country. Some cells in the database contain more than one hyperlink. I placed each hyperlink in textboxes so the row numbers in the database would correspond to those in the register. I'm trying to write a macro right such that there is a command button i placed in the register workbook called "Update". Basically what I would like to happen is that when a new row is inserted in the register (could be at the end or in between information since the register is alphabetical so if a new project comes up in a country starting with let's say H, when I insert a new row under for example row 25 in the H section in the register, a new row will appear in the database under row 25 in the H section), and the "Update" button is clicked, a new row would be inserted in the database workbook at the exact same location. It would be great if the information entered in the register workbook in the new row(s) would be updated in the database workbook too, but if that is too much, I just need the rows, so at least we can keep up with the new information in the database and will not have to go back to the register some time in the future and manually mass update it with all the new projects entered. Am I making sense? I literally have never coded a macro before, i don't know the language or syntax at all. ANY help would be appreciated. i tried fighting to write a piece of code but as expected it isn't working. I can post it also if that is necessary. Sorry this is so long!

Thanks!
Reesha