Excel Qty->Part Number->Serial Number VBA

[ProdigyOne]

Hello,
I'm working on a spreadsheet to keep track of certain orders for some customers who want the info.

Right now i have a "Quantity" column which can range from 1 to 200, a "Part Number" column, and then a "Serial Number" column.

My problem:
"Quantity" will always be one cell
"Part Number" will always be one cell
"Serial Number" will need to be able to input as many serial numbers as there are quantities

I haven't figured out a way to enter in the serial number info in an organized way.

Is there some sort of pop-up VBA form i could use that when "serial number" cell is clicked it automatically asks for the proper number of serial numers and stores them somewhere as well?

Any ideas are appreciated. I've thought of some ways to do it, but nothing that makes me think "yes, that is the proper way to get this info and store it".

Thanks!

 

[galileogali]

Maybe, I am not understanding, but

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub

 Set fs = CreateObject("Scripting.FileSystemObject")
    Set D = fs.GetDrive(fs.GetDriveName(fs.GetAbsolutePathName(ThisWorkbook.Path)))
Target.Value = D.SERIALNUMBER

End Sub

GALILEOGALI