MODELNUMBER123 Part 1A 123 Part 1B 0 Part 2A 234
Part 2B 0 Part 3A 456 Part 3B 432 I'm
implementing a part scanning system For some models we only use Part 1A
and some models Part 1A and Part 1B. Same thing for Parts 2 and 3. In such
cases I'll have a dummy barcode that will read 0 The scanning should
always start in cell C3, where I will scan the model number of the unit That
will populate values from B4 to B9. Cursor will move to cell C4 where I
will scan Part 1A and cursor will move to cell C5 and so forth. ( (I can do
this far. I need help from the next step.) After scanning all parts (upto
C9)the cursor should move from cell C9 to cell C3 and delete all the values
from B4 to C9. I need a mcro for this step. I attached the file.-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Macro_Scanning.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
