Find value and lookup row number to use as reference

[woody83]

Hi,
Ive been struggling getting a fault reporting system to work. My macro knowledge only goes as far as recording and editing code to suit.

I have a set of spreadheets on different computers that I have a macro that copies lines of data into another excel file and distributes as required, and also into an overall 'master' sheet.

However, I now need to be able to enter in the 'status' column when a job is completed, and copy back to the other files.

Below is a more simple version of the spreadsheet. I want to find the status column and then look down this to find the 'closed' jobs, then look for the 'fault' number. This 'fault' number matches another spreasheet, so the row needs to be copied and paste over the corresponding row. I need to loop this down the wole status column until I reach the bottom and repeat for the 'in prog' jobs too

fault test type status date comment
1 1 water open
2 3 water open
3 2 electrical closed
4 1 hardware open
5 1 software in prog
6 1 hardware open


This is what i started with but im aware its mostly rubbish

Please Login or Register  to view this content.

I hope this is clear, really appreciate any help as you can see im not getting very far

[Cutter]

@ woody83

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.