Recent content by accessabel

Oh I am trying to make a list of numbers all ending in 00, 20, 40, 60 and 80 turn into 01, 02, 03... 19, 20, 21, 22, 23... 39, 40, 41, 42... etc. The code above also copied any cells next to the main list of numbers so that the shipping information would stay with the expanded list. The above...

Hi, my company ships items in packs of 20 and only tracks them as a lot or 20pack serial number. Well that serial number is say xxx00 which expands to xxx01, 02, 03... up to xxx19. I have an excel VBA script that will do this function for me (insert new row, add +1, repeat up to x times). But I...