newwb

Guys, is there a way to filter by each name in column D and then save these as a separate CSV file and name it based on the name in column D. Something similar to the below code which works fine but this saves based on the worksheet name. Ideally i dont want to create a new worksheet for each...

Hi All, HELP, I'm confused.... The below code works at home on excel 2016 however in work where we use 2010 it fails on the wb.sheets(arr).copy line any suggestions? is it really a version difference or am i missing something? Thanks in advance for any suggestions :) Sub copysheets()...

Hi all, A few weeks ago I asked about creating new workbooks with specific numbers of sheets. I was given a code that stores the default number of sheets to be created in a new workbook, then changes the Application.SheetsInNewWorkbook property to the desired of new sheets, creates a workbook...

Hi Guys, I have the below code which works great but is there a way to overwrite the files if they already exist Sub Run() Dim ws As Worksheet, newWb As Workbook Application.ScreenUpdating = False For Each ws In Sheets(Array("Bethan", "Hannah")) ws.Copy Set newWb = ActiveWorkbook...

Here is my simple code, found online. Sub test2() ' copies a worksheet into a new file and saves it onto desktop Dim newWB As Workbook Sheets("Sheet1").Select 'Add a new workbook and copy the Members sheet over Set newWB = Workbooks.Add ThisWorkbook.Sheets("Sheet1").Copy...