Just to clarify a little.... the contract numbers in the list correspond
exactly with the tab names.

"Marc T" wrote:

Hi,

I'm struggling to get my head aorund how to do this, so sorry if it's a
little garbled!

I have the following macro to copy the contents of a tab in a large
worksheet to a new one (as values):

Sub DumpToFile()

Dim c As String
c = Worksheets("CONTROLS").Range("C4").Value
Sheets(c).Select
Sheets(c).Copy
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

End Sub


What I have is a list of contract numbers, and I want to put a checkbox next
to each... and have the macro do the routine above for each contract that has
a checkmark beside...

Can this be done?

Many thanks!
Marc