Hi, I wonder whether someone may be able to help me please.
I'm using the code below to extract data from a master sheet ("All Data") and paste relevant data into sheets whose name match a value within a given column set here in the code: Set ws = Sheets(rng.Value)
Trying to keep this post as simple as possible, the script does two jobs: The following section searches for four specific sets of information which match a given set of criteria, namely "TM - DIR", "Enhancements", "TM - IND" and "TM - OVH".Please Login or Register to view this content.
The next section pastes the data onto the 'Destination' sheets and it's this I'm having difficulty withPlease Login or Register to view this content.
I'm trying to write the code so that when the piece of data which matches the first search i.e. for the value "TM - DIR" I would like to paste the results on row 8, for the data which matches the second search i.e. for the value of "Enhancements" paste on row 9 and so on for the remaining values, but I receive a 'Subscript out of range' error'.Please Login or Register to view this content.
I've tried to correct this over the last few days without success.
I just wondered whether someone may be able to look at this please and offer some guidance on how I can resolve this.
For ease I've attached a sample file. To run and see the error, please click the 'Launch' button.
Many thanks and kind regards
Chris
Bookmarks