Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help to paste
i have a cell which will have a number put in it.how do i tell exel to paste
to different cells (depending on what number is put in the cell) EXAMPLE : if the cell contains "1" then paste "hello" in cell A2 if cell contains "5" then paste "hello" in cell F6 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help to paste
You can put a formula in cell A2:
=if(A1=1,"Hello","") And cell F6 would have the formula: =if(A1=5,"Hello","") If you did not want to put formulas into all of the cells you want the message to appear then you would have to use some VBA. I could provide some sample codes, but for a new user this might be a little overwhelming. "ian123" wrote: i have a cell which will have a number put in it.how do i tell exel to paste to different cells (depending on what number is put in the cell) EXAMPLE : if the cell contains "1" then paste "hello" in cell A2 if cell contains "5" then paste "hello" in cell F6 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help to paste
right click sheet tabview codeinsert thismodify to suitSAVE
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$G$1" Then Exit Sub Cells(Target + 1, Target).Value = Target End Sub -- Don Guillett SalesAid Software "ian123" wrote in message ... i have a cell which will have a number put in it.how do i tell exel to paste to different cells (depending on what number is put in the cell) EXAMPLE : if the cell contains "1" then paste "hello" in cell A2 if cell contains "5" then paste "hello" in cell F6 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help to paste
thanks for replying maybe i do need a VB sample.
Maybe I originally explained it To simply :( Basically instead of hello i really want to print an address on a different sheet(one address line per cell vertically) but i have about 100 different addresses. Example: IF cell a2 on sheet 1 says "1" then copy the address (which is also on sheet 1 to cells d1 to d5 on sheet 2 if cell A2 on sheet 1 says "54" then copy THAT address (which is also on sheet 1) to cells d10 to d15 on sheet 2 "RJ" wrote: You can put a formula in cell A2: =if(A1=1,"Hello","") And cell F6 would have the formula: =if(A1=5,"Hello","") If you did not want to put formulas into all of the cells you want the message to appear then you would have to use some VBA. I could provide some sample codes, but for a new user this might be a little overwhelming. "ian123" wrote: i have a cell which will have a number put in it.how do i tell exel to paste to different cells (depending on what number is put in the cell) EXAMPLE : if the cell contains "1" then paste "hello" in cell A2 if cell contains "5" then paste "hello" in cell F6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Paste Special Problem | Excel Discussion (Misc queries) | |||
Copy and paste Excel chart in Word -- font compresses | Charts and Charting in Excel | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |