Excel VBA - Paste Data to Specific Tab Name

[becca_832313]

Hello, I have a workbook containing two data sets, one on Worksheet1 and one in Worksheet2. Within each data set, Column A contains a standard mapping (this mapping is dynamic and is based on the rows of data). I have an existing macro that filters on Column A in Worksheet1 and create a new worksheet for every unique value in Column A - each of these worksheets names match the filtered criteria. I would now like to Filter Column A in Worksheet2, based on the same mapping criteria, and past the values to the bottom of the newly created tabs . How do i specify the tab name to paste the data into based off of what is currently filtered?

 

[vcoolio]

Hello Becca,

Are you saying that you wish to create more worksheets from the unique values in Column A of Worksheet2?

or

Are you saying that you wish to copy/paste the relevant data from Worksheet2 to the new worksheets created from Column A of Worksheet1?

Uploading a sample of your workbook will help tremendously in helping you sort this out.

Cheerio,
vcoolio.

 

[jolivanes]

Don't know if I understand it right, but maybe

For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row
    With Sheets(Cells(i, 1).Value))
        .Cells(.Rows.Count, 1).End(xlUp).Offset(1).Resize(, 7).Value = Cells(i, 1).Resize(,7).Value
    End With
Next i

Like vcoolio suggested, if you could upload a workbook with a before and after in it to a site like "dropbox", that would be a great help.