Get data from another sheet

[grahamscotland76]

Hi There, Wonder if you can help me with some VB. I'm just getting into it and need a little hand in what I am doing

I've attached a sample spreadsheet of what I've sort of done.

On the sheet SCHED there is a list of runs by drivers, and drops

In cell A1 on each of the other sheets is the name of a run (Run 1, Run 2 etc)

What I would like is a macro/active button on each of the other sheets that will take the value in cell A1, look at the column B of the SCHED sheet, and copy all rows (columns A to G) that have that value in it, and paste them onto the other sheet starting in cell A3.

Or would it be possible to name the other sheets Run 1 etc, and have a macro on the SCHED sheet to move any rows to with RUN 1 in column b to the sheet Run 1, RUN 2 in column b to the sheet Run 2, etc etc.

The number of runs can vary from 1 to 50.

Thanks In Advance

Graham

[patel45]

Attach again the file with sheet a compiled as you want

[jaslake]

Hi grahamscotland76

Welcome to the Forum!

This code in the attached and appears to do as you require. Let me know of issues.

Please Login or Register  to view this content.

[grahamscotland76]

Hi Jaslake

That is almost what I am looking for. I've attached another file to see if it is possible to makeit slightly better.

When the RUN x tabs are made, it is possible to use the sheet called Masterrun as a template so that the RUN x tabs look like RUN 1 tab?

Ta


GrahamCopy of Transport v1.1.xlsm

[jaslake]

Hi grahamscotland76

Replace the code with this code

Please Login or Register  to view this content.