macros for copy paste from one sheet to another sheet column

 Question:

  I have little knowledge in macros. But I can't able to find out answer to me. I have an excel workbook with two sheets naming MMS DATA anad RHQ DATA.Sheet RHQ DATA have some texts in column D ranging from D2 to D591. In sheet MMS DATA is also having same text in column E ranging from E2 to E591 with random order. Now I want to match text iteratly sheet MMS DATA column cell text E2 with whole cells text in column D of sheet RHQ DATA and if match found, (for eg:if match found in D111 of sheet RHQ DATA with E2) then same ROW B column of RHQ DATA (ie,B111) cell text has to be copied and paste in same searched ROW at column F of MMS DATA (ie,MMS DATA F2) and iterate the procedure upto E591 in sheet MMS DATA......Please help me out....




 Answers:
 

New user with English as a second language?
In order to get best responses you need to take the time to structure and format your questions so we can understand them.
This is what I think you mean -
There is a sheet "RHQ DATA" with columns
   |   A   |   B   |   C   |   D   |
1  |       |       |       |       |
2  |       |This   |       |This   |
3  |       |is     |       |is     |
4  |       |the    |       |some   |
5  |       |info   |       |text   |
*  |       |       |       |       |
589|       |to     |       |and    |
590|       |copy   |       |so     |
591|       |:-)    |       |on     |
and sheet "MMS DATA" with columns
   |   A   |   B   |   C   |   D   |   E   |
1  |       |       |       |       |       |
2  |       |       |       |       |and    |
3  |       |       |       |       |so     |
4  |       |       |       |       |on     |
5  |       |       |       |       |text   |
*  |       |       |       |       |       |
589|       |       |       |       |This   |
590|       |       |       |       |is     |
591|       |       |       |       |some   |
and we want sheet "MMS DATA" to match the text in its column E with column D or "RHQ Data" to produce:
   |   A   |   B   |   C   |   D   |   E   |
1  |       |       |       |       |       |
2  |       |to     |       |       |and    |
3  |       |copy   |       |       |so     |
4  |       |:-)    |       |       |on     |
5  |       |info   |       |       |text   |
*  |       |       |       |       |       |
589|       |This   |       |       |This   |
590|       |is     |       |       |is     |
591|       |the    |       |       |some   |
If this isn't your question please edit it so it is clear what you are after.
If this is the question then this is not a programming task, it is a lookup task for which Excel has plenty of built-in capability.
One way to accomplish it is to put this formula into each cell of column B of "MMS Data":
=OFFSET('RHQ Data'!$B$1,MATCH(E2,'RHQ Data'!$D$2:$D$591,0),0)


Commentaires

Enregistrer un commentaire

Posts les plus consultés de ce blog

XAJAX with PHP – The future of web development

XAJAX is a class library or framework written purely on PHP that allows you to easily create powerful, Web-based, Ajax applications or plugins. You can download xajax framework from http://sourceforge.net/projects/xajax/ XAJAX is easy to impement. You need to just include XAJAX library, instantiate the xajax object, and register the name of function (or an object or class method) which you want to call from XAJAX framework. xajaxResponse() is an object to return the results of our requests as XML formats. Then call that particular function you want from xajax framework through your HTML or javascript. That's it. XAJAX takes care of most everything else. You just need to write the PHP functions and returning XAJAX XML responses from them, which is made extremely easy by the xajaxResponse class. Code: <?php include './xajax/xajax_core/xajax.inc.php'; $xajax = new xajax(); $rqstAdd =& $xajax->register(XAJAX_FUNCTION, 'ad...
Lire la suite

XAJAX with PHP – The future of web development

XAJAX is a class library or framework written purely on PHP that allows you to easily create powerful, Web-based, Ajax applications or plugins. You can download xajax framework from http://sourceforge.net/projects/xajax/ XAJAX is easy to impement. You need to just include XAJAX library, instantiate the xajax object, and register the name of function (or an object or class method) which you want to call from XAJAX framework. xajaxResponse() is an object to return the results of our requests as XML formats. Then call that particular function you want from xajax framework through your HTML or javascript. That's it. XAJAX takes care of most everything else. You just need to write the PHP functions and returning XAJAX XML responses from them, which is made extremely easy by the xajaxResponse class. Code: <?php include './xajax/xajax_core/xajax.inc.php'; $xajax = new xajax(); $rqstAdd =& $xajax->register(XAJAX_FUNCTION, 'a...
Lire la suite

Database connection pooling in ADO.Net

Imagine a situation that multiple users are connecting the same database through our application. In an application establishing a database connection and logging into it is a time consuming activity. It needs several seconds for every time it establishes a connection. So opening and maintaining a database connection for each user is not an ideal solution. When the number of users increases, and if the system�s memory set is limit, probably it leads to a system crash. This problem can solve through connection pooling. A connection pool is a cache or pool of database connections maintained by the application so that the connections can be reused when the database receives future requests for data. Establishing once and reserving it for future request can essentially improve the overall performance of the application. In connection pooling, after a connection is created, the connection object is placed in the pool. When a simultaneous connection request is made later, ...
Lire la suite