Search : in
By :

Select data and paste in single cell

Last answer on May 11, 2009 7:01:57 am BST mary, on May 7, 2009 11:05:02 am BST 
 Report this message to moderators

Hello,

Can any one please provide me with macro such that depending upon the data of Coloum A ,it should select the data in Coloumn B and Concatenate and paste in a cell in Coloum C with a space between each String.
please help me

Configuration: Windows XP Internet Explorer 6.0

Best answers for « select data and paste in single cell » in :
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Ask your question Reply

1

 mubashir aziz, on May 11, 2009 7:01:57 am BST

I don't know why you are asking for macro ????? Your question is not clear you are depending on col A then Select Data B and paste in C ...

I think you can write formula in C as

=If(A1="good","Good"&" "&B1,"")

and drag it down ...

Suppose in A1 you have good and in column B mark ... then result will be as "Good 50" .......


Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz
Ask your question Reply
They need your help