Excel 2010. When I scan data into last cell, I need excel to drop down to next row

[Dan L]

When I scan data into cells on one row, when I get to the last cell column of data, After I scan in data, I want to drop down to next row, column 1.

[abousetta]

Hello and welcome to the forum,

It's not clear from your post what you are doing. Please explain further and provide a sample workbook so we can understand better.

[Dan L]

I am using a scanner to enter data into a 2010 excel spreadsheet. It has 7 columns. When I scan into the 7th column, I need that last cell entered to drop drop down to the next row 1st cell.

[abousetta]

How does the scanner know where to put the data? Does it put in the active cell and then the next six columns next to it? Therefore if the selected cell is A2 then A2:A7 would be filled after the scan?

[Dan L]

Cell A1 is highlighted first. After each scan, it kicks to the next cell to the right. Right now, after we scan into cell G1 it goes to cell H1. I need the data on the next scan after G1 to go to A2

[abousetta]

Maybe something like this in the sheet code where the data is being inputted:

Please Login or Register  to view this content.

It assumes that once the data is inputted in Columns 1-7, column 8 is selected. This will trigger the change event to move to the next row starting at column 1.

[Dan L]

This works great....but I can get the code to save. If I save the file, the cofe disappears.

[abousetta]

You are saving as xlsx. You need to save as xlsm (macro-enabled) or xls (older format) or xlsb (binary format). Personally I would recommend the first (.xlsm).

[Dan L]

You are saving as xlsx. You need to save as xlsm (macro-enabled) or xls (older format) or xlsb (binary format). Personally I would recommend the first (.xlsm).

It wont work as an xlsm....do you have an email I can se nd the file to??
o

[abousetta]

You could upload it to the site using the attachment button on the 'Go Advanced' form.

[Dan L]

I have attached the file

You could upload it to the site using the attachment button on the 'Go Advanced' form.

[abousetta]

Have a look at this attachment.

abousetta

[Dan L]

I will get it a try first thing in the morning....can't thank you enough for this.

Dan

[abousetta]

Glad I could help. Let me know how it goes.

abousetta

[Dan L]

PERFECT !!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you so much for your help !!!!!!!!!

Glad I could help. Let me know how it goes.

abousetta

[abousetta]

Thanks for the feedback. Please mark the thread as Solved.

Good luck.

abousetta