I couldn't understand the criteria part of this.
My criteria would be to select items = 1 in column A and filter out others.
How would I do this?

"Roger Govier" wrote in message
...
Hi Dylan

You could write VBA code to do it, but another alternative would be to
use Advanced Filter to bring the data across to you second sheet.
Take a look at Debra Dalgleish's site for some excellent instruction on
how to do this.
http://www.contextures.com/xladvfilter01.html#ExtractWs
There are also some sample workbooks on the site you can download

--
Regards

Roger Govier


"dd" <dd.dd wrote in message
...
Roger,

Thanks for your quick response.

I understand the copy link procedure, but way you are suggesting will
involve a lot of manual time in excel for each survey. I am looking
for is
something which will only copylink the items that are flagged as being
behind programme in the "Mark as Behind" column.

something along the lines of
If A5 is null do nothing
If A5 =1, copylink this row (or specific cells in this row) to
Worksheet 2.

The problem I see in making the copied rows consecutive. I wonder if
this
would involve a VBA routine where the routine works on the selected
items as
a single object?

This is my general understanding of the problem anyway.

Any suggestions?

Regards
Dylan Dawson


"Roger Govier" wrote in message
...
Hi Dylan

On Sheet2 in cell B2
=IF(Sheet1!$A2="","",Sheet1!B2)
Copy to C2 and E2:F2
Copy down as far as required

If your sheet names are not Sheet1 etc. but have spaces in the name,
enclose with single quotes e.g.
'Main Sheet'!$A2
--
Regards

Roger Govier


"dd" <dd.dd wrote in message
...
I am weakest in excel; I have an understanding of VBA in Word and I
have
attended an advanced Access course.

I have this problem in excel, I have no idea what track to take with
it,
Hence the cross posting between programming and worksheet functions.

This workshbook is to be used by our surveyors to input data from
site
inspections.

I have a table on one worksheet with the column headings:

Mark As Behind
Task No
Task Description
Contractor's Estimate
Our Estimate

I have a table on another worksheet with the column headings:

Mark As Behind
Task No
Task Description
Total Weeks for Task
Contractor's Estiamte
Our Estimate

Worksheet one is percentages of work carried out. We use this to
estimate
the overall progress.

Worksheet two is weeks of work carried out. This calculates the
average no
of weeks behind schedule.

I only use the tasks which are behind programme in table two. Hence
the
column 'Mark as Behind'. How do I programme excel, to use this
column,
to
take the tasks Marked as Behind into table two?

Regards
Dylan Dawson
Building Surveyor
Glasgow, Scotland