Sorry for the delay, Elton. I keep looking at this, not understanding it and therefore doing something else instead ... instead of just asking:
Quote:
|
I have a Range of Data in Worksheet1 (A1-AT44).
|
Got it.
Quote:
|
I need to copy 4 cells from Worksheet2 to whichever cells (i.e. AK16, AN16, AQ16 and AT16; AK20, AN20, AQ20 and At20; etc)....
|
Wait, you said the data was in Sheet1. Why are you copying it from Sheet2, then? I think that was a typo; elsewhere you repeat that you're copying from Sheet1 to Sheet2. I'll keep reading.
Quote:
|
....to whichever cells based on name association of (John Doe) that is in both Worksheets.
|
Nope, here's where you lose me. What do you mean by a "name association"? Do you mean that somewhere in a cell is a person's name that is identical to a workbook filename, or worksheet name, or something? You have "John Doe" somewhere "in both worksheets" (the From and the To worksheets, I suppose you mean), and you want your program to
find the same name and copy values somewhere on the same row as the person's name in the To worksheet? I really need you to spell it out.
Quote:
|
I would have to associate Worksheet1 A16 (name) and its "Range to Copy" cells (AK16, AN16, AQ16 and AT16) with Worksheet2 name and then copy Worksheet1 "Range to Copy" into the the appropriate Worksheet2 cells. Then repeat that for another Unique Name.
|
Ok, maybe I have a better guess. You want to copy selected data from Sheet1 to Sheet2. Both sheets have person's names (I'll assume in column A); for each row in Sheet1—that's the source row—you want your program to a) find the row in Sheet2 that has the same name—the target row—and b) copy certain cells from the source row in Sheet1 to the same cells in the target row in Sheet2.
But wait, maybe not:
Quote:
|
I was thinking of just manually telling the formula to look only in 1 Worksheet for each name and copy the Worksheet2 cells into the appropriate cells of Worksheet1.
|
Dang, here you reverse it again; now you're copying Sheet2 into Sheet1. I'm pretty sure I'm confused.
Quote:
|
I have up to 4 or 5 Worksheets, so I could just change which Worksheet it searches in.
|
"Dang", again; I thought you were just copying data from Sheet1 to Sheet2. That's only two worksheets; I counted them carefully. :-)
How'm I doing? Pretty bad, I suspect.