Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same value in cel
Hi all I wold like to ask about microsoft exel macros , how i can make maib macros for this : i have two columns whit same value example 1 A1 B1 2 12 48 3 74 12 4 14 74 5 48 14 6 5 65 how a can move value in same cell ,make this 1 A1 B1 2 12 12 3 74 74 4 14 14 5 48 48 6 5 65 Thenk -- ceconi ----------------------------------------------------------------------- ceconik's Profile: http://www.excelforum.com/member.php...fo&userid=2806 View this thread: http://www.excelforum.com/showthread.php?threadid=47580 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same value in cel
Put this formula in C1
=IF(COUNTIF(B:B,A1)0,A1,B1) and copy down Then select column C, copy, EditPastespecial and select Values, and exit. Then delete column B. -- HTH Bob Phillips "ceconik" wrote in message ... Hi all I wold like to ask about microsoft exel macros , how i can make maiby macros for this : i have two columns whit same value example 1 A1 B1 2 12 48 3 74 12 4 14 74 5 48 14 6 5 65 how a can move value in same cell ,make this 1 A1 B1 2 12 12 3 74 74 4 14 14 5 48 48 6 5 65 Thenks -- ceconik ------------------------------------------------------------------------ ceconik's Profile: http://www.excelforum.com/member.php...o&userid=28066 View this thread: http://www.excelforum.com/showthread...hreadid=475801 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same value in cel
Try
Sub CopyValues() With Sheets("My Sheet") .Range("A2:A6").Copy .Range("B2").Pastespecial End With Application.CutCopyMode = False End sub You'll need to rename the sheet and redefine the ranges to suit your needs. "ceconik" wrote: Hi all I wold like to ask about microsoft exel macros , how i can make maiby macros for this : i have two columns whit same value example 1 A1 B1 2 12 48 3 74 12 4 14 74 5 48 14 6 5 65 how a can move value in same cell ,make this 1 A1 B1 2 12 12 3 74 74 4 14 14 5 48 48 6 5 65 Thenks -- ceconik ------------------------------------------------------------------------ ceconik's Profile: http://www.excelforum.com/member.php...o&userid=28066 View this thread: http://www.excelforum.com/showthread...hreadid=475801 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same value in cel
JNW Wrote: Try Sub CopyValues() With Sheets("My Sheet") .Range("A2:A6").Copy .Range("B2").Pastespecial End With Application.CutCopyMode = False End sub You'll need to rename the sheet and redefine the ranges to suit your needs. "ceconik" wrote: Hi all I wold like to ask about microsoft exel macros , how i can make maiby macros for this : i have two columns whit same value example 1 A1 B1 2 12 48 3 74 12 4 14 74 5 48 14 6 5 65 how a can move value in same cell ,make this 1 A1 B1 2 12 12 3 74 74 4 14 14 5 48 48 6 5 65 Thenks -- ceconik ------------------------------------------------------------------------ ceconik's Profile: http://www.excelforum.com/member.php...o&userid=28066 View this thread: http://www.excelforum.com/showthread...hreadid=475801 Thenks, Themks , Thenks -- ceconik ------------------------------------------------------------------------ ceconik's Profile: http://www.excelforum.com/member.php...o&userid=28066 View this thread: http://www.excelforum.com/showthread...hreadid=475801 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same value in cel
JNW Wrote: Try Sub CopyValues() With Sheets("My Sheet") .Range("A2:A6").Copy .Range("B2").Pastespecial End With Application.CutCopyMode = False End sub You'll need to rename the sheet and redefine the ranges to suit you needs. "ceconik" wrote: Hi all I wold like to ask about microsoft exel macros , how i can mak maiby macros for this : i have two columns whit same value example 1 A1 B1 2 12 48 3 74 12 4 14 74 5 48 14 6 5 65 how a can move value in same cell ,make this 1 A1 B1 2 12 12 3 74 74 4 14 14 5 48 48 6 5 65 Thenks -- ceconik ------------------------------------------------------------------------ ceconik's Profile http://www.excelforum.com/member.php...o&userid=28066 View this thread http://www.excelforum.com/showthread...hreadid=475801 Thenks ,Evrethink is ok for this example , but i would like to compar two cell and if value from cell is same copy and paste only this , no evrethink Thenks agai -- ceconi ----------------------------------------------------------------------- ceconik's Profile: http://www.excelforum.com/member.php...fo&userid=2806 View this thread: http://www.excelforum.com/showthread.php?threadid=47580 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same value in cel
Thenks ,Evrethink is ok for this example , but i would like to compare
two cell and if value from cell is same copy and paste only this , no evrethink . Thenks again If the value is the same, why do you need to copy and paste it? Can you explain more. JNW Thenks ,Evrethink is ok for this example , but i would like to compare two cell and if value from cell is same copy and paste only this , no evrethink . Thenks again |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same value in cel
two cell and if value from cell is same copy and paste only this , no evrethink |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|