call a sheet by cell info

[Lball]

HI,
If I have Sheets named for any data in Col "D", how do i write code to copy selected data to that named sheet?

Range(Cells(j, "A"), Cells(i - 1, "H")).Copy
Sheets???.select ("THIS IS WHERE I WANT TO CALL WORKSHEET NAMED FOR CELLS (i,"D")
Cells(14, "A").Select

 

[cb12]

I'm not entirely following you but I am assuming that the variable 'i' is a row number. So you could declare a variable to pick up the relevant cell reference. As an example:

SheetName = Cells(i, 4).Value
Sheets(SheetName).Activate

However if you're copying the data into A14 why not try:

SheetName = Cells(i, 4).Value
'Your Range'.Copy Destination:=Sheets(SheetName).Cells(14, 1)