Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Offset / if statement
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Offset / if statement
Resolved · Medium Priority · Version 2003
Reply 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.
For upcoming training course dates see: Pricing & availability
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
Attached files...
Copy Using Offset.xlsReply Fri 12 Sep 2008, 11:55Delegate Richard said...
RE: Offset / if statement
Cheers Carlos - much appreciated!
Richard.
|