Between Sheets

F

fvcyo

New Member
Joined
Sep 2, 2004
Messages
16
I have information in a cell of sheet1 and desire to place it in another cell in sheet2 I can do it by a reference but if I erase the value of the cell of sheet1 i like to keep the value in the cell of sheet2

i want to do this automatic if i delete a cell of sheet1 don't erase a cell in sheet2. i can do with copy-paste special but i try a difference way. Anyone Help me..
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sort by date Sort by votes
Try this at worksheet event (VBA)
Place it at Sheet1 of your example
Code: 
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("a1").Value = "" Then Exit Sub
If Target = Range("a1") Then Target.Copy Destination:=Sheet2.Range("a1")
End Sub

Target=range("a1") represents your cell at Sheet1
destination:=sheet2.range("a1") represents the cell of sheet2
Change accordingly
 
Upvote 0
Excelent is works

Now i try to copy many different cells from sheet1 to sheet2 how can do that?


Try this at worksheet event (VBA)
Place it at Sheet1 of your example
Code: 
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("a1").Value = "" Then Exit Sub
If Target = Range("a1") Then Target.Copy Destination:=Sheet2.Range("a1")
End Sub

Target=range("a1") represents your cell at Sheet1
destination:=sheet2.range("a1") represents the cell of sheet2
Change accordingly
Click to expand...
 
Upvote 0
I can take care of that. Since there are replies, I will simply lock the Spanish thread, not delete it.
 
Upvote 0
if it's specified cells at sheet1 to specified cells at sheet2 then copy code as many times you like for your needs. If it's for any cell then inform. It would be better to clear your intentions, so i can help you better. What columns do you use from sheet1, specify range, where to at sheet2 e.c.t.
 
Upvote 0
it's not a range of columns, i have random cells over the sheet1 so i try to copy to sheet2.

if it's specified cells at sheet1 to specified cells at sheet2 then copy code as many times you like for your needs. If it's for any cell then inform. It would be better to clear your intentions, so i can help you better. What columns do you use from sheet1, specify range, where to at sheet2 e.c.t.
Click to expand...
 
Upvote 0
there is no problem if cells are random at sheet1. The problem is where exactly you want them to be placed at sheet2?
e.g you change cell ("b2"), ("a6"), ("d13").
You want them at the exact places at sheet2, at column a:a, at a row? where?
 
Upvote 0
ok in sheet2 i want to copy over a row.


there is no problem if cells are random at sheet1. The problem is where exactly you want them to be placed at sheet2?
e.g you change cell ("b2"), ("a6"), ("d13").
You want them at the exact places at sheet2, at column a:a, at a row? where?
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
copy cell and cell above onto different sheet, under the next available line.
Replies
5
Views
187
Alex Blakenburg
A
R
  • Solved
Paste values in another sheet after last Cell containing Data
Replies
5
Views
170
Umma123
U
M
  • Question Question
2-Way Cell Referencing
Replies
1
Views
136
jkpieterse
jkpieterse
C
  • Solved
List Results from All Sheets Search
2
Replies
16
Views
218
MikeVol
MikeVol
U
  • Solved
Doing a search for text within a call, from entries in a defined name range
Replies
3
Views
115
Upex
U

Forum statistics

Threads
1,223,958
Messages
6,175,629
Members
452,661
Latest member
Nonhle

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top