Previous Topic Next Topic

Copying a value in a cell

Closed
Kirbo - Sep 4, 2009 at 08:09 AM
 Blocked Profile - Sep 4, 2009 at 12:05 PM
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 response

Answer 1 / 1
Blocked Profile
Sep 4, 2009 at 12:05 PM
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
0

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Formula to Find&replace blank cells in excel
onetuff_z -
tstobb -

11 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response