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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 17, 2013 at 11:47 AM
Related:
- How copy a particular text from one column of sheet to another
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- How to open excel sheet in notepad++ - Guide
- How to take screenshot of excel sheet on laptop - Guide
- Mark sheet in excel - Guide
5 responses
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!
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!
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 12, 2013 at 10:44 AM
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
@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
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.
:)
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.
:)
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
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
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
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
555
Sep 17, 2013 at 11:47 AM
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
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
Sep 10, 2013 at 10:33 PM
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
Sep 11, 2013 at 10:17 AM
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!