Entering data into the next row automatically

**lesoies** · 10-01-2012, 10:03 AM

Hello I am trying to make my macro so the data I eneter is generated into the next available row.

However, I can only seem to generate the content a few rows down with

Whenever I try changing the cells it returns an error and was hoping for any help

Thanks

**DannyJ** · 10-01-2012, 10:11 AM

Hi Lesoies,

Is there ever a row that is guaranteed to have data in it?

Regards

Danny

**lesoies** · 10-01-2012, 10:15 AM

Thanks for the reply Danny, yes there is the top row which contains the headings. Then below is the data so atm I only have it so i take that line of code out and data is only entered on the second row or put that line in and it gets generated 6 rows down

**DannyJ** · 10-01-2012, 10:18 AM

Try

Please Login or Register  to view this content.

with E1 being the column that is guaranteed to be populated everytime. For every column you are across from where you intend to start (For example if the column always populated is C you put C1 where E1 is but you information starts from A1 then you will need to change the offset(1,0) to offset(1,-2)

That should work fine for you.