Hi!
I'm all new to VBA so I barely understand anything. I'll try to explain as best as i can.
I am renting out lifts and I need to have an overview over their current addresse and how many parts are rented out etc. I have made a VBA macro which activates when i push the button 'Generer'. It saves Sheet1 as pdf in a designated folder on my computer and it opens an email with the document attached I can send to the customer and the warehouse for packing.
However what I'm struggling with is that I want the new address in sheet1 to overwrite the current address on sheet2 when I'm done and push generate. I have a list of different lift types and serialnumbers. So I want the address i change in sheet1 to overwrite the address in sheet2 for in the row of the correct serialnumber.
I have attached my excel workbook and a poorly drawn description in paint. I'm really not sure if this explains anything, but any help at all would be great!