98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Offset / if statement
Offset / if statement
Resolved · Medium Priority · Version 2003
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
Attached files...
Copy Using Offset.xls
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. |
Excel tip:Remove unused toolbar buttonsAre there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following: |
