Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My basic goal is to be able to have a user input 3 pieces of information and
have Excel increment the data based on the information entered. More specifically, the user will enter "Job Number", "Number of Lots", and "Number of Parts in each Lot" as such: Job Number: 12345-67-8910 Number of Lots: 3 Parts per Lot: 10 I would like for Excel to increment the data and print in a format that will act as a "label". The data should be incremented as follows: 12345-67-8910 1 1 12345-67-8910 1 2 12345-67-8910 1 3 ...etc. 12345-67-8910 2 1 12345-67-8910 2 2 12345-67-8910 2 3 ...etc. 12345-67-8910 3 1 12345-67-8910 3 2 ...etc. Spaces are not required between the job number, lot number, and part number, i just added them for emphasis on what i would like to achieve. I am guessing that the best way to achieve this is to use macros, but i am not very "macro savvy". Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data table based on data table | Excel Discussion (Misc queries) | |||
Choosing data based on Match to several items | Excel Worksheet Functions | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Retreive data based on multiple column input | Excel Worksheet Functions |