new book vba

  1. S

    VBA code to copy data based on criteria

    Hi There, I am looking for a VBA code that can copy all the rows (Incl Headers) based on criteria in specific column. Scenario :- I have a File with 8 different sheets and different information. Commonly, every sheet has a "Status" column. I want to filter the status column and check for...
  2. J

    Excel macro that will fill cells with data from a source document to a new workbook template

    Hey Everyone, I am new to this site and want to thank anyone who takes the time to look at this. For my job, we are given a list of items that have a corresponding item number, item code, unit, quantity, etc. We take these individual items and we take the information and put it into a...
  3. P

    VBA to search column and copy entire rows to new sheet

    Hello, I have a problem where I want to be able to search a particular column and then copy that entire row to a new workbook based on the value found in the particular column. I have the following worksheet called '2016':- <tbody> A B C D E F G H I J K L M 1 DATE NAME DATE PAID INV NO...
  4. R

    vba code to save an existing workbook with a new name

    I have this code that, in an existing open workbook (let's call it "Template"), looks for any tabs that have a name begining with "CC". For each of these tabs, it copies the tab into a new workbook, deletes any extra tabs, then saves the new workbook to my desktop. Sub Copy_Save_CC()...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top