How to create add character to differentiate goods while doing inventory

thorito

New Member
Joined
Feb 15, 2010
Messages
3
Hi, I need to create a macro that when is enabled, it automatatically adds a charather as the leading character preceding the serial number for the items to be scanned (i.e.- a "u" for used item). When the macro is disabled, it should not add any charater. Any help?

Thanks
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

You'll need to give some more details. For starters, how is your scanned information making it into Excel? And how does the code know what character to add to any scanned item?
 

thorito

New Member
Joined
Feb 15, 2010
Messages
3
Hi, thank you for your reply.

This macro is required to differentiate the used ("u") vs new articles in a store while we do inventory count and we scan the article ID with barcode scanners. The used articles are in different bins, but when we do the inventory count its very tedious to add a "u" as the leading character and for such reason we are looking to add a button or somenthing that adds the leading "u" while the operators scans the bins of used product. Once he finish with that section he can then disable the button of used product and continue to scan the rest of the articles without a leading "u".

I hope this clarifies more my requirement

Thanks
 
Last edited:

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
I hope this clarifies more my requirement

Not really.

To restate, can you tell us how your barcode equipment interacts with Excel?

How does the data make it in, what format does it come in (multiple cells or a single one), etc.?

Without specifics no one's going to be able to help out. Think of this as trying to explain what you're doing to someone who has never even seen your process. I understand what you're trying to do, but you need to detail how that process makes it into Excel.
 

thorito

New Member
Joined
Feb 15, 2010
Messages
3

Ok, let's try this again with more details.

We do inventory cycle counts once a week and to do so we scan the barcode of each article in the store using a barcode reader that feeds Excel via serial port interface. The data is entered in a specific column (I.e. column A) and every time a new article is entered it goes to the next row in the same column.

We have three categories of products as follows:

New
Used (u)
Defective (d)

When we scan the product ID of all items on the above categories, we need to find a a way to automatically add a specific character to the product ID to be scanned for each category. For example if we are going to scan the used articles, we would like to click in a button that automatically tells excel to capture the next product ID to be scanned with a leading "u" for used. Once the inventory count for used product is completed, the operator should turn off the button and then if more items are scanned then Excel keeps data without affecting the next product IDs.

A similar procedure should apply when the operator decides to scan the inventory of defective product but in this case the scanned items should include a leading "d".
 

Watch MrExcel Video

Forum statistics

Threads
1,108,621
Messages
5,523,947
Members
409,543
Latest member
LaMaqu1na

This Week's Hot Topics

Top