Tue 9 Sep 2008, 16:39Delegate Richard said...
Richard has attended:
Excel VBA Intro Intermediate course
Offset / if statement
Hi, do you have an example of an offset function used in conjunction with an if statement, e.g if cell A1 contains 'Customer ABC Ltd' , then copy the cell containing 'Customer ABC Ltd' to one cell to the left of the copied cell and copy it down 6 rows, or six cells?
Hope im clear, thank you.
Fri 12 Sep 2008, 11:36Trainer Carlos said...
RE: Offset / if statement
Hi Richard
Attached you will find a Workbook with a list of names starting in cell "A1", that also contains a macro "CopyData".
Running this macro, which starts looking in cell "A1", it will copy the relevant cell 6 columns to the right if the cell contains the words "ABC Ltd"
The macro runs until it finds a blank cell in column A
Hope this helps
Carlos
Copy Using Offset.xls
