Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Set aCell = wb2.Sheets(1).Columns(1).Find(What:="Orange", LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False) If Not aCell Is Nothing Then wb1.Sheets(1).Range("FetchedValue").Value = _ aCell.Offset(, 6).Value Else MsgBox "Orange sales not found" End If
|How do I select one row from one sheet and pass the row to another sheet in Excel?||22||70|
|Excel Conditional Statements||11||32|
|Excel VBA - macro in one workbook with another open||4||19|
|Excel - click on a cell and have everything in another cell clear||13||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!