Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2016, 06:44 AM
Elton Wolter Elton Wolter is offline copy cells from a worksheet into other worksheets based on Criteria Windows 10 copy cells from a worksheet into other worksheets based on Criteria Office 2013
Novice
copy cells from a worksheet into other worksheets based on Criteria
 
Join Date: Apr 2016
Posts: 2
Elton Wolter is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-09-2016, 10:41 AM
BobBridges's Avatar
BobBridges BobBridges is offline copy cells from a worksheet into other worksheets based on Criteria Windows 7 64bit copy cells from a worksheet into other worksheets based on Criteria Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 04-10-2016, 12:23 AM
macropod's Avatar
macropod macropod is offline copy cells from a worksheet into other worksheets based on Criteria Windows 7 64bit copy cells from a worksheet into other worksheets based on Criteria Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #4  
Old 04-13-2016, 05:38 AM
Elton Wolter Elton Wolter is offline copy cells from a worksheet into other worksheets based on Criteria Windows 10 copy cells from a worksheet into other worksheets based on Criteria Office 2013
Novice
copy cells from a worksheet into other worksheets based on Criteria
 
Join Date: Apr 2016
Posts: 2
Elton Wolter is on a distinguished road
Default

Quote:
Originally Posted by BobBridges View Post
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.
Bob,

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.
Reply With Quote
  #5  
Old 04-16-2016, 08:44 AM
BobBridges's Avatar
BobBridges BobBridges is offline copy cells from a worksheet into other worksheets based on Criteria Windows 7 64bit copy cells from a worksheet into other worksheets based on Criteria Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
Reply

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
copy cells from a worksheet into other worksheets based on Criteria 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
copy cells from a worksheet into other worksheets based on Criteria Cells from other worksheets apear on current worksheet Equilar Excel 3 05-03-2010 01:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft