sheetsnew

Hello, I have the below code but I am looking to add something to it. Once the Macro has run but before the message box stating update complete, what I would like it to do is: go to Sheet "CAPA Log", copy rows A1:P1, paste in an e-mail, then copy the last row with data (A:P) and paste that...

Hello, I have a procedure that makes a copy of a sheet that on the new sheet I do not want it to copy the embeded formulas, just the values, which works fine. But, I do need it to have one cell in particular, Range("D7"), to have this formula in it =SUM(D4:D6) in case the user has the need to...

Hey everyone, I'm currently working on a project, where a Userform generates a PDF report. It already extracts Project Title, Project Area and saves it to a chosen destiny location. I also have a Listbox containing checkboxes and multiple selection in the same form. What I want it to do is...

Hi all, I really hope someone can help with this so that I can finish this project and move on. I have the following code which copies data from one sheet and tries to find the matching supplier in another sheet. if it finds the supplier it pastes to the next empty row below that supplier...

Hi, I have the following code which creates a table in a worksheet based on data copied from another worksheet. However it throws up a syntax error and everything I have tried isn't working. With Sheets("Data") x = .Cells(1, .Columns.Count).End(xlToLeft).Column On Error Resume...