From the course: Excel: Learning VBA

Unlock the full course today

Join today to access over 24,000 courses taught by industry experts.

Refer to cells using the OFFSET property

Refer to cells using the OFFSET property - Microsoft Excel Tutorial

From the course: Excel: Learning VBA

Start my 1-month free trial Buy for my team

Refer to cells using the OFFSET property

“

- [Instructor] When you create an Excel workbook, you should give it consistent structure so you know where each data point appears in relation to the others. A consistent structure means you can use the distance from one cell to another, called the offset, to refer to cells in For Next and other loops. In this movie, I will show you how to use the offset property to collect data from a suggestion form. My sample file is "05_04_Offset", and you can find it in the Chapter 5 folder of the Exercise Files collection. This workbook has two worksheets and you can see on Sheet 1, I have a suggestion box and there's room for a name, an email, and then the suggestion. This data will be written to Sheet 2. And you can see that I already have data that has been collected. So I have two rows with suggestions that have already come in. So the goal will be to fill out the suggestion box and then take its data, find the first…

Contents