#1
|
|||
|
|||
copy cells from a worksheet into other worksheets based on Criteria
I am new to the forum.
I need to copy cells from 1 worksheet into other worksheets based on an name association. worksheet 1 has name and 4 cells of data associated with that name. I need to locate all worksheets in the workbook that have that name but need the data copied to the appropriate cells in their respective worksheets. |
#2
|
||||
|
||||
We'd need more detail to answer that, Elton, but let's start here: What do you mean by "a name association"? How (for example) are four particular cells in a worksheet "associated" with that worksheet's name?
My next question might be where you said "I need to locate all worksheets in the workbook that have that name". If the first worksheet is named "Worksheet-A" (for example), then there's no point in going through the workbook to see what other worksheets are named "Worksheet-A"; only one worksheet can have that name. But one question at a time; maybe your answer to the first question will clear up the second before I ask it. |
#3
|
||||
|
||||
Replicating the data on other worksheets is fairly straightforward, but you haven't given anywhere enough information for that. We'd need to know what sheet the data are being transferred from, which cells the data (including the 'association' data) are in, plus the corresponding information about each of the destination sheets.
I'd also have to question why you're trying to replicate the data on four worksheets, instead of having all the data on a single worksheet.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
Quote:
Thanks for the reply. In answer to your 1st paragraph. What I mean is I have a Range of Data in Worksheet1 (A1-AT44) that I need to copy 4 cells from Worksheet2 in the Workbook to whichever cells (i.e. AK16, AN16, AQ16 and AT16; AK20, AN20, AQ20 and At20; etc) based on name association of (John Doe) that is in both Worksheets. I would have to associate Worksheet1 A16 (Unique Name) and it's "Range to Copy" cells (AK16, AN16, AQ16 and AT16) with Worksheet2 Unique Name and then copy Worksheet1 "Range to Copy" into the the appropriate Worksheet2 cells. Then repeat that for another Unique Name. 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. I have up to 4 or 5 Worksheets, so I could just change which Worksheet it searches in. |
#5
|
||||||
|
||||||
Sorry for the delay, Elton. I keep looking at this, not understanding it and therefore doing something else instead ... instead of just asking:
Quote:
Quote:
Quote:
Quote:
But wait, maybe not: Quote:
Quote:
How'm I doing? Pretty bad, I suspect. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
a macro that can copy data from copy.xls to our current excel macro.xls based on criteria: | udhaya | Excel Programming | 1 | 11-12-2015 10:12 AM |
Selecting random cells based on criteria | mesTrethowan | Excel | 11 | 10-28-2015 06:51 AM |
Can you copy & paste cells across worksheets and preserve reference to worksheet? | New Daddy | Excel | 2 | 11-27-2013 07:19 AM |
Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |
Cells from other worksheets apear on current worksheet | Equilar | Excel | 3 | 05-03-2010 01:40 AM |