Copying multiple cells into new sheet

Basically I need some help, fairly new to macros but have a basic understanding of them, I currently have 3 sheets of which contain separate project management information, titled York, Sheffield and Doncaster. They contain tasks that need to be done, with a simple yes no completion row. what I would like to do is create a master spreadsheet so that if a tasks has been completed with a yes or no in the row next to the task in these 3 they would paste the task done into the master, if that makes sense ?

Thanks

Hi,

Assumptions.

Task exists in column A of the three sheets and column B with yes/no
Sheets has headers.

Please Login or Register  to view this content.

Steffen Thomsen

Thanks Steffen,

Almost right, the Yes/No column is in F, all other information such as dates and days remaining to complete the task are in the other columns. If I where simply change the cell range would this still work ?

Usama Rafique

Hi,

Yes, just change the cell reference.

Steffen Thomsen