baxius
12-10-2019, 07:27 AM
Hello,
I've been trying to create a decent inventory labeling VBA, but couldn't do it. The problem i have is , that i don't know how to code that an offset value would be inserted in another worksheet and printed out. To put it simply, i attached some screens shots and the Workbook
In the first one (Sheet1) is a made up label for a box. X is the box code, and Y is when it arrived.
And the second one (Sheet2) is the box registry sheet. Where when a box code is entered, a macro timestamps it, uses the scanned to determine the expiry and so on.
The thing i would like to achieve is when i enter a Code in T column the adjacent value in column H would appear in sheet1 location X+"Code" and adjacent value from column I is entered in location Y +"Reg.d." and then the E10:E14 cells are printed out creating a label.
I'd really appreciate your help or tips on how to achieve something like this. Thank you for any tips and help.
25594
2559525596
I've been trying to create a decent inventory labeling VBA, but couldn't do it. The problem i have is , that i don't know how to code that an offset value would be inserted in another worksheet and printed out. To put it simply, i attached some screens shots and the Workbook
In the first one (Sheet1) is a made up label for a box. X is the box code, and Y is when it arrived.
And the second one (Sheet2) is the box registry sheet. Where when a box code is entered, a macro timestamps it, uses the scanned to determine the expiry and so on.
The thing i would like to achieve is when i enter a Code in T column the adjacent value in column H would appear in sheet1 location X+"Code" and adjacent value from column I is entered in location Y +"Reg.d." and then the E10:E14 cells are printed out creating a label.
I'd really appreciate your help or tips on how to achieve something like this. Thank you for any tips and help.
25594
2559525596