new workbook

  1. N

    Cell value update issue after running VBA code

    Good Day to you all. I am having an issue with the code below. I have spent hours trying to get it to run correctly but being a bit of a novice at coding I've hit a brick wall now. I would really appreciate your help. The problem is if I run the code, then when asked I choose 'Yes' on the...
  2. B

    When copying Excel sheet to a new workbook, images are not being copied VBA

    Hello all, I have created the VBA code to copy an Excel sheet to a new workbook in .xlsx format as I need the new workbook to be free of macros. However, the sheet I'm copying has the company's logo and I need it to be on the new workbook as well. However, is not doing it. The code I'm using to...
  3. J

    VBA code to locate specific already filtered columns by name and paste into a new workbook

    Hi All, So to give some background, i have a large data set (60k plus rows and 90 plus columns) that i need to filter and create a new workbook using specific columns. The size of the file changes daily, and columns are taken out and added. So i had to keep updating the previous macro i had...
  4. tomsov

    Saving excel sheet using inputbox to select date range.

    Hello, I've been working on a complicated workbook but have ran into a problem that I can't seem to solve. I need to output a list of invoices to an external application (it can be imported as an .xls file but must be in a stand alone workbook on Sheet 1 for this to work). I have so far managed...
  5. A

    VBA Save active sheet as new Workbook in specific Location Values only

    Hello i need a macro that will Save the current active sheet as a workbook Any help would be greatly appreciated Requirements: Save active sheet as a workbook Values only Save to specific location E.G. "C:\Users\Username\Desktop" Save the file name as "text" & " " Active sheet name
  6. M

    Help: Macro for copying old workbook columns to new workbook

    Hey guys so im struggling with making a macro: To start; i get inventory lists that don't have my data on it and have to go copy columns from multiple tabs. I was creating the macro below but the problem am having is: How can i make this work on any 2 workbooks i have (ex: this one is copying...
  7. G

    VBA: Use loops to copy a groups of worksheets into multiple workbooks

    Hello, I created a macro that uses a counter to create 3 worksheets for each country included in a data tab. The data tab can have a variable number of countries, so the macro counts the number of countries and creates a Cover Sheet, Expense Sheet, and Income Sheet for each country (e.g. the...
  8. A

    GetSaveAsFilename with creating new workbook

    Hello everyone, I'm going to complete my simple application relating to creating new workbook, copying data sets from the workbook where I run my macro, pasting the set to the new one with possibility to point out a path. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As...
  9. A

    Creating New Worksheet/Workbooks based on Existing Data from Master Sheet

    I am in the process of automating some of my workflow and cannot figure out how to best approach this situation. I have an inventory sheet that I would like to create new sheets off of based on categories. Each category would need its own file generated along with all items included...
  10. R

    copy row to new workbook if a cell is 0.1 or less

    hello i have a workbook titled 3 months and in this wb i have Sheet1 which contains data i need copying to a new wb if cell in column D is 0.1 or less, this could be 1 or 200 rows. this new wb would need to be saved in a different filepath. i'm assuming this is possible but i am not sure how...
  11. K

    Macro to copy selected worksheets to new workbook

    Hi, I've seen some similar posts, but most have been too specific for my needs. I have a workbook with 150+ worksheets, containing reports for 60+ employees. All have at least two worksheets; many have three or four. I need to be able to group the two, three, or four worksheets for each...
  12. A

    Copying closed workbooks to a new workbook

    I need to be able to have individual sheets from different WKBKS to link data to another WKBK which is my dashboard. What I am trying to achieve is I need is to be able to open all WKBK'S in a Folder automatically and import the data, sheet1 from each WKBK so that the sheets copied will...
  13. J

    Delete worksheets after copying to new workbook

    Hello, can anyone please provide guidance on how to edit the following code to *delete* the worksheets beginning with "Labor BOE" from my initial/primary excel worksheet, after these sheets are copied into a new workbook? Here is the code being utilized: Sub Export_X() Dim Sh As...
  14. J

    Worksheets copied into new workbook - Cell Color/Fill Changes - Unintentional - Preserve Cell Color/Fill

    Hello, I am using the following code (which works great) to export the sheets named "Labor BOE xxxx" after my spreadsheet creates multiple copies of a template worksheet, inserts summary tables, and populates the summary tables. The one issue that I haven't been able to figure out is... after...
  15. J

    Copy Sheets - Not working

    Hello, I am using the following code to copy multiple worksheets into a new workbook. Unfortunately, the worksheets aren't copying over. I am wondering if creating the new workbook is changing my "Activeworkbook" which is referenced on line 6. Any thoughts on how to correct this? Also, I...
  16. J

    Copy specific worksheets to new workbook (as values). Save as

    Hello, I am attempting to do the following: Copy all worksheets whose name ends in "-PP" into a new workbook (formats, values - NO formulas) Open a pop-up box in the new workbook that asks the user to enter the version number Open the save as window and save the file to the user's desktop as...
  17. B

    VBA Command Button turn off linking to source workbook

    I am trying to accomplish something that I would suspect is a common type of problem, but I have been all over the internet and I'm having trouble finding it: I have a master excel workbook with lots of macros, formulas, and data from many sources which I copy each week to do my planning. I...
  18. F

    Copy array to another workbook

    I have some complicated VBA code to populate a 2-D array (250 by 366). When the array has been populated, I want to copy the array to another workbook. I believe there is a way to efficiently copy en masse with very simple code. Any thoughts?
  19. C

    VBA Copy New Sheet & Existing

    Hi, I'm creating new files (over 40) based on a list. Column M On "Lookup" contains the list and new file names. Ideally the new file contains 1) A copied tab "Account_Risk_Assessment" 2) the original "Lookup" tab I've pieced together this from other forums... Sub accountlisting()...
  20. D

    Need one more bit of VBA to save wksht as values in new wkbk

    Hi all--I have the need to save only the values from one sheet of a workbook, as .csv in a new workbook that is named according to the value in cell A2. The sheet is populated according to formulas. I have a nice, simple VBA doing everything right...except it copies the formulas over, and the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back