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
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Pi copy and paste - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- How to compare two Excel sheets with varying data ✓ - 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
