new sheet

  1. G

    Find & copy into new sheet with macro

    Hello, I have a problem that I think can be solved with a macro, but im not sure where to start. I have a number of spreadsheets that are set up with varying amounts of data from several sites, with header information followed by the data. I want to take one part of the header info (station...
  2. S

    database

    i'm trying to create a database wherein when you double click on the figures (total), it links you to a different sheet that shows how the computation is made in order to arrive at the total. just how do i do that? thanks! your answers are much appreciated! :)
  3. R

    Check name of new Worksheet before adding it

    Hi I'm creating a new sheet with my solver and I created a button to assign a name to the worksheet. If the new name already exists, I get a warning message, the macro fails and a new sheet called eg Sheet 1 is created. How can I write a "If" to warn the user he entered a name that...
  4. F

    macro to copy and name a sheet

    I was hoping to get some help with a macro. I need to copy a master sheet and create a number of new sheets equal to the number of items in a list. Thus, if I have five buildings Building A Building B Building C Building D Building E The macro would create five sheets, named "Building A"...
  5. N

    Previous sheet reference

    I have a spreadsheet that displays the weekly sales of my employees. I have a table that displays the weekly sales and then one below it on the same sheet that displays the year to date sales which are calculated by adding the current week sales to the previous weeks (which are displayed on the...
  6. L

    Macro to copy and create new sheet

    I have a workbook where i create "daily reports". I'm trying to find a VBA solution to "copy" the most current report, and create a new tabsheet. (the same way you would right click on the tabe, and select "create a copy". I've tried recording a macro to do this, but the macro keeps trying to...
  7. StanAalbers

    Hide rows if value in column does not match (vlookup)

    Dear all, On "Sheet2", there is data unsorted. Every row is a sales lead, entered by an employee. There are of course multiple leads per employee. This sheet is supposed to be hidden/protected. The name of the employee is in row E. On "Sheet1", I want a cell (or listbox, whatever works...
  8. Data base- arrange by brand

    Hi, I have a data base of 8200 products, each product has a code of 6 to 7 characters, the 3 first characters tell me the brand of the product. I will like my database separated by brand of product, hopefully a sheet per brand. Each product have 4 columns : code, description, und, price. can a...
  9. O

    Cut rows into new sheet based on changing value in column

    Hi, does anybody know how I could cut rows from a range of data based on a changing value in a column. I have a whole set of data within which column K represents Currency. Currently I have my data sorted by Currency then a line is inserted with every Currency change. Set up as...

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