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

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

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

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

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

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

Same value in cel
 

two cell and
if value from cell is same copy and paste only this , no evrethink