Hi all,
I have a macro in a template workbook (jobprogress) that once run, updates another workbook (summary) by adding the data to the next free line.
However, A3 in 'jobprogress' is the project number. Everytime that particular 'jobprogress' is updated (by filling in different columns from B3 to Z3) it sends the data to 'summary' and I end up with multiple rows of the same project - not very useful for a summary sheet! Basically, I would like "before sending data, check if same project number exists in 'summary', if it does then delete that row and insert new data". Is this possible?
Here is the code I have put together with the help of the internet!:
and the function:Please Login or Register to view this content.
Any help would be greatly appreciatedPlease Login or Register to view this content.
Threads also open:
http://www.mrexcel.com/forum/showthread.php?t=569573 & http://www.ozgrid.com/forum/showthread.php?t=157022
Bookmarks