Copying a value in a cell

[Closed]
Report
-
 Blocked Profile -
Hello,

Hi, I am trying to take a value from one excel worksheet and have it carryover to another worksheet, but I don't know how to create the formula.

Also, is there a way to create multiple responses in one cell based on mulitiple input values from another cell?

Kirbo

1 reply


Well try this

Sub test()

Sheet1.cells(x,y).copy
Sheet2.activate
Sheet2.cells(a,b).select
activesheet.paste

End sub

x, y and a, b are the cells positions, the will copy from sheet1 cells(x,y) to sheet 2 cells (a,b)

well you can use a text array with a particular delimeter

Exemple: cells(1,1) = "a | B |c | d |etx "

| is the delimeter, to recover the data seperately just split them into an array later