How copy a particular text from one column of sheet to another

Closed
gvgbabu Posts 5 Registration date Friday September 6, 2013 Status Member Last seen September 17, 2013 - Sep 6, 2013 at 09:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 17, 2013 at 11:47 AM
Hello,

how to copy a particular text from one column of sheet to another sheet. For example

i have a text in cells of a column in sheet1
i am showing two columns only but actual more columns with this text so it should be iterative


LENGTH: 3000.0 mm CROSS SECTION: 600.0 mm X 600.0 mm COVER: 40.0 mm
LENGTH: 2000.0 mm CROSS SECTION: 500.0 mm X 600.0 mm COVER: 40.0 mm


In sheet2 I have a table
vba program for this format

HEIGHT BREADTH WIDTH cover
3000 600 600 40
2000 500 600 40




please help me to come out of this problem

thanks in advance

gvg

5 responses

Blocked Profile
Sep 6, 2013 at 09:29 PM
good evening....

Please understand there are absolute, and relative references....

In this case, I beleive you should be able to reference an absolute, so...

if sheet1 cell "a1" contains "40".

In sheet2 cell "a1", you would have a reference...

=Sheet1.Cells(1,1)

The result would be: 40 on sheet 2 in cell A1 (1, 1)

I believe you could also reference a cell with

...Range("A1")

Have Fun!

gvgbabu Posts 5 Registration date Friday September 6, 2013 Status Member Last seen September 17, 2013
Sep 10, 2013 at 10:33 PM
hi ac3mark

thank you for your quick reply

i did not understand please elaborate it
one more thing how can add code for iteratively getting the required text


thanks

gvg
0
Blocked Profile
Sep 11, 2013 at 10:17 AM
I am really sorry, but I cannot make it simpler, only more complex.

On your workbook, there are typically 3(ea) tabs, labeled "SHEET1", "SHEET2", "SHEET3". These are the worksheets, and their names are "SHEET1", SHEET2", and SHEET3".

To acheive a function, you click on any cell, in this case, click on "SHEET2", and then click on cell "A1". Now type in

=SHEET1!RANGE("A1")

Now click back to "Sheet1". Click on cell "A1". Now type in
hello world

Now click back to "sheet2". What did you see?

Please use this as a wireframe, and give it a try. It is not as hard as what it sounds.

Have Fun!
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 12, 2013 at 10:44 AM
@Mark, aren't you confusing formula's with a bit of VBA? I'm sure you know what I mean.

@gvg, it's not clear how your sheet is made up (you say you show 2 columns but the sample shows 3x : which would suggest 3 columns, or did you mean rows?) and how you change certain info into headers (CROSS SECTION becomes BREADTH WIDTH).

If you are willing to upload your file (www.speedyshare.com or ge.tt) and create the header for sheet 2, things will get a lot clearer.

Best regards,
Trowa
Blocked Profile
Sep 12, 2013 at 11:51 AM
Yes, I can only make it more complex, not simpler. I didn't want to add another layer onto this one.
Once we get passed the diplaying of text from one sheet to another, we can address the DELIMITING of text strings.
=MID(A1,FIND(":",A1)+1,FIND(":",A1)+LEN(FIND(":",A1)))
in cell B1 would result in
3000.0

as I said, I can only make it more complex.
:)
0
Blocked Profile
Sep 12, 2013 at 12:06 PM
YOu could aslo not worry about code and use the built in functions....

Go to Data tab, then Text to Columns option. Later, choose "Delimited" option and then select "other" and put a ":" [colon]
I have used this many times.

I am assuming you are using 2010Excel
//ark
-Contributor
gvgbabu Posts 5 Registration date Friday September 6, 2013 Status Member Last seen September 17, 2013
Sep 13, 2013 at 11:28 AM
hi mark and Trowa

thanks for your replys

www.speedyshare.com/srUVS/excel.xls

this is the link for my excel model file

please see and guide me

gvg

Didn't find the answer you are looking for?

Ask a question
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 17, 2013 at 11:47 AM
Hi gvg,

After looking at your data I would go with Mark's suggestion to use Delimiter.
Try to use fixed width and record it into a macro so you probably only have to do it once (depending on the amount in digits in the numbers).

Best regards,
Trowa