Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
Option Explicit Sub FindAndOffset() 'This routine should find a specific value within a column and copy a corresponding value from another column in the same row. 'E.g. If a fare is "Fixed", rather than calculated, copy the fare from the "Client Fare" Column to the "Amended Fare" Column. Dim rFixed As Range ' Set Range to find fixed fares in Column B (Column 2) Set rFixed = Range(Cells(2, 2), Cells(1, 2).End(xlDown)) Debug.Print rFixed.Address 'If FixedFare = "F", then copy the Client Fare (Column D - Column 4) to (Column G - Column 7) rFixed.Find(What:="F").Offset(0, 5) = rFixed.Find(What:="F").Offset(0, 2) 'Next Find????? 'I am trying to do this without using a loop. Is this possible End Sub
|Excel: Comparing the Values in One Column with the Values in Another||2||28|
|From where do I download MySQL for Excel?||2||11|
|Combining Data between multiple excel workbooks||11||3|
|Find missing excel values from Column A and B||4||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!