ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need formatting help (https://www.excelbanter.com/excel-worksheet-functions/64906-need-formatting-help.html)

Bornloser

Need formatting help
 

I know SQUAT about Excel, but here is what I need help on. Here at
work, we are inputting scanned serial numbers from 2 scanners into
Excel. This has been accomplished. HOWEVER, the scanned items just
keep overwritting the old number. As a new number is scanned in, all I
want to do is to put it 1 column below the last one. Is there a simple
formula for this?
Thanks


--
Bornloser
------------------------------------------------------------------------
Bornloser's Profile: http://www.excelforum.com/member.php...o&userid=30411
View this thread: http://www.excelforum.com/showthread...hreadid=500785


Bornloser

Need formatting help
 

Anybody???


--
Bornloser
------------------------------------------------------------------------
Bornloser's Profile: http://www.excelforum.com/member.php...o&userid=30411
View this thread: http://www.excelforum.com/showthread...hreadid=500785


Ron Rosenfeld

Need formatting help
 
On Thu, 12 Jan 2006 13:22:37 -0600, Bornloser
wrote:


I know SQUAT about Excel, but here is what I need help on. Here at
work, we are inputting scanned serial numbers from 2 scanners into
Excel. This has been accomplished. HOWEVER, the scanned items just
keep overwritting the old number. As a new number is scanned in, all I
want to do is to put it 1 column below the last one. Is there a simple
formula for this?
Thanks


How exactly, are you inputting the numbers?

If you are typing them into the worksheet directly, all you need to do is hit
the down arrow after each entry.

If there is code being used, you'll need to post the code.


--ron


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com