Recent content by sln8458

Well I've managed to resolve my problem:) I named cell C18 as target_pr. Then using the code below I found the matching value in col A. This finds the location just fine. Then to add a new row at that location: This duplicates the row and leaves the active cell as the one which requires a...

Hi all, I have a workbook with multiple worksheets, the workbook is used for project cost monitoring with a new worksheet for each project. The sheets have unique names associated with their project. Col's A-M are currently used. Col A contains the Purchase Requisition No. Col D contains...

Hi All I'm Steve, an engineering designer by trade (a draughtsman really) and dabble a bit in excel as part of my day job. My knowledge of programming is zero, tho' I have tried to learn :banghead: so I rely on forums like this one and you guys/girls for help. SteveN