To find, copy the corresponding value, paste
Closed
aishu
-
Nov 12, 2011 at 02:43 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 12, 2011 at 10:05 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 12, 2011 at 10:05 PM
Related:
- To find, copy the corresponding value, paste
- How to paste photo in resume - Guide
- Copy and paste fonts - Guide
- E with accent copy paste - Guide
- Pi copy and paste - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 12, 2011 at 10:05 PM
Nov 12, 2011 at 10:05 PM
before running this macro select any cell with aleast one row and one column between the main data and the selection.
for e.g. the main data from A1 to B6 do not select cell in row no.7 or column C.
main data is like this
a 1
s 2
d 3
f 4
g 5
h 6
the cursor is kept (in other words select) cell A13
now run the macro
for e.g. the main data from A1 to B6 do not select cell in row no.7 or column C.
main data is like this
a 1
s 2
d 3
f 4
g 5
h 6
the cursor is kept (in other words select) cell A13
now run the macro
Sub test()
Dim r As Range, cfind As Range, x
Set r = Range("a1").CurrentRegion
x = InputBox("the string or number you require for e.g. s")
Set cfind = r.Find(what:=x, lookat:=xlWhole)
If Not cfind Is Nothing Then
cfind.EntireRow.Copy Selection
End If
End Sub
