Hey guys,
Is it possible to select one column from a defined sheet name (Sheet.Name "Invoice" - Column V) and copy to ALL worksheets in the book and place in column V?
The catch is that each worksheet has a different name, and there are a variable number of worksheets...
I'm currently using the below for a similar sort of thing. Can this be adapted?
Is this possible and / or easy?
Cheers guys
Is it possible to select one column from a defined sheet name (Sheet.Name "Invoice" - Column V) and copy to ALL worksheets in the book and place in column V?
The catch is that each worksheet has a different name, and there are a variable number of worksheets...
I'm currently using the below for a similar sort of thing. Can this be adapted?
Code:
For Each wks In Worksheets
wks.Activate
[COLOR=Red] OTHER CODING (irrelevant for this purpose)
[COLOR=Black]Next wks
Call WriteDataToText[/COLOR]
[/COLOR]
Is this possible and / or easy?
Cheers guys