Hello all,
First time posting so please let me know if I've missed anything and I'll quickly fix it.
I'm looking to set up a sheet where barcodes (4 to 5 digit numbers) will be scanned into Column A. Then, every time a cell in Column A is filled, the adjacent cell in Column B is filled with a number (2 to 3 digit number) determined by a fixed cell, for example D4. I do not want the number in D4 to change for every scan but a simple =IF(A2="","",$D$4) for example won't suffice because the number in D4 will be changed periodically but when it is I would like the previous entries in Column B to keep their assigned numbers.
To further explain the situation, we have lots of barcoded bags which will be scanned as they're thrown into large, numbered crates. I want to set up the Excel file so that the user can simply type in the first crate number into one cell at the start of the session then scan bags as they throw them into the crate. Then, once that first crate is full, the user can then type in the number of the next crate and continue to scan and throw bags into that new crate. Therefore, at the end of the day I can look at the Excel file and it will show me which crate each individual bag is in.
I'm using Excel 2013 on Windows 7 Enterprise.
I'm sorry if I haven't explained it well enough but I've been going mad trying to learn VBA/userform stuff all day which is potentially overcomplicating things.
Cheers,
Chris
First time posting so please let me know if I've missed anything and I'll quickly fix it.
I'm looking to set up a sheet where barcodes (4 to 5 digit numbers) will be scanned into Column A. Then, every time a cell in Column A is filled, the adjacent cell in Column B is filled with a number (2 to 3 digit number) determined by a fixed cell, for example D4. I do not want the number in D4 to change for every scan but a simple =IF(A2="","",$D$4) for example won't suffice because the number in D4 will be changed periodically but when it is I would like the previous entries in Column B to keep their assigned numbers.
To further explain the situation, we have lots of barcoded bags which will be scanned as they're thrown into large, numbered crates. I want to set up the Excel file so that the user can simply type in the first crate number into one cell at the start of the session then scan bags as they throw them into the crate. Then, once that first crate is full, the user can then type in the number of the next crate and continue to scan and throw bags into that new crate. Therefore, at the end of the day I can look at the Excel file and it will show me which crate each individual bag is in.
I'm using Excel 2013 on Windows 7 Enterprise.
I'm sorry if I haven't explained it well enough but I've been going mad trying to learn VBA/userform stuff all day which is potentially overcomplicating things.
Cheers,
Chris