part2

I have been tasked with a extracting some data from a spreadsheet not being that good i would like some help with VBA all the data is on sheet 1 and there is duplicated through out. the way it is layed out is where ever there is a part number there is a serial number in the right hand cell...

Hi All, Just need to bounce an idea off you all and wondered if and how i could get round this issue. I have built a form that contains the serial number of a product that has come into repair. What i want to be able to to is to have a list of parts that make up this single product but have...

Here is the current module I'm using. It works perfectly to save the workbook in the same folder as the Master Workbook. How ever I would like to save it to a sub-folder called "F:\O&M Consultant's Calculation\using "part1" as the variable\" & part1 & " O&M " & part2 & " .xlsm" Every time I...

Afternoon all stuck again if some can help me out, I have a userform with several text boxes on it ie a 7 x 3 grid I want to be able to populate the contents depending upon a variable for example if I have var = 3 string1 = "part1" string2 = "part2" so this would populate row 3 on my grid...