1. L

    How to make two new tabs pull data from each other

    I have a document that I’ve made with two tabs “shift report” and “machine data” which both pull various formulas and data from each other Is there a way I can create a button / macro that would copy both tabs but the formulas for the new ones would correspond with each other Eventually you’d...
  2. S

    Renaming a tab

    Hi i have 10 tabs that starts from "prod_xxx_F1" , "prod_xxx_F2", ... so on. How is there a way to keep F1, F2,... by deleting others. Thanks
  3. S

    Unable to copy or move sheet in Excel 2016

    Hello everyone!! i have this excel version when i try to make a duplicate sheet in workbook it showing like this, only 2 button are working that is View code and protect sheet: why other are not working??? please help me , i am worroy about this
  4. W

    Conditional Formatting referencing multiple sheets Hi Excel Users! I need some assistance in having a formula created that will highlight a cell red when the following conditions are met, however, some of the information is on different sheet tabs. On Saturday...
  5. C

    Inserting text from another tab

    Good Morning, I have an events spreadsheet and would like to do the following. The tab with the information is called Events Notices as follows: <tbody> SUBJECT LINE FULL NOTICE 50's Sock Hop Toss on your bobbi socks & poodle skirts then head down to where DJ (this needs to pick up the...
  6. C

    Matching cells, adding blank lines

    Hello, I've got an idea for a spreadsheet but am not sure where to get started. I have two tabs (Tab A and Tab B); each tab contains materials for a job. Each group of materials "A" column is the system into which the material was taken off. I would like to have all of my column A from Tab A...
  7. C

    What's the most efficient way to remove all the salary info from my model without ruining all the calcs?

    I work in Finance and I need to send out our budget model to one of our business partners, but she can't see all the salary info we have in there. One option is to go tab by tab (there are probably 30) and manually copy/paste values in the person-by-person salary calc, then delete the person by...
  8. J

    Summarize 3 Tabs into 1

    Hi all I have a customer order form spreadsheet with 3 existing tabs, each tab has a different product range and there are rows for each different product with columns for price, description, SKU and quantity ordered. I need some help please with what formula to use so that on a new fourth tab...
  9. L

    Automated Stock Sheet

    Hi, I’m trying to find a solution to automate a stock sheet. I have a register of various sizes based on diameter and length on one tab. On other tabs I’m trying to look at the first tab and automatically add new items or down date quantities you can see on the used / create tab, it has two...
  10. R

    Case Statement and For next loop

    Hello, My workbook has a tab for each month. When I’m in a specific month, I run the macro below to add a name to the Totals tab. It places the name on the first available row for that months chart. I created name rages for column A for each months chart on the totals tab. Example...
  11. T

    Help Getting Date on Tab

    Hi, I have a macro that puts data that is in a cell on the tab. Currently I turn the date into Week XX and currently names the tab of the current sheet Week XX. I know you can not put / on the tab. Is there anyway I can Create Week 45 11.3.19 on the tab? I need to replace the / in the date...
  12. F

    Copy Data from One Workbook to Another

    Hello all, Should be a simple piece of code, but I'm getting a timeout error. I've got a workbook, let's call it "summary", which I want to put a macro in that will open another workbook, select all the data from a specific tab "CFG", and paste it into a tab, of the same name "CFG" within the...
  13. C

    List all instances of a value from a list of mixed values to separate tab

    I have a column of data on a tab called "Data Dump" in column A. The column contains 5 different product codes. I'm trying to do something along the lines of: If A2 on the "Data Dump" tab equals "S-7", copy and paste A2, B2, C2, and D2 to a new tab called "S-7" starting with cell A9. Do this...
  14. A

    How to insert in cell A1 the name on the tab

    Is there a way to insert the name on the tab of an excel sheet into cell A1 without having to type it every time?
  15. P

    Keyboard Shortcut to View all Worksheets (Excel 2010)

    Hi, Is there a keyboard shortcut to view all the worksheets in a workbook? I know how to right click on the <> arrows to view all the worksheets but wondered if there was a shortcut? Thanks Peter
  16. M

    Dynamic: Finding the Min and assigning to that category

    I have a spreadsheet with 2 separate sheets set up as follows: Assignment: <tbody> Department Bucket Shift State Product Home Health Nights Toys Nights Sporting Goods Nights Grocery Days Toys Days Furniture Days Pets Days </tbody> Summary: <tbody>...
  17. D

    Right Click Sheet Tab

    Hi, how can I hide the 'right click' options on a Worksheet Tab (not the Worksheet Cells) pls... I have a Worksheet that I lock with VBA (password) and I dont want users to be able to unlock hte Sheet through the 'right click' option, eg: Insert / Delete / Rename, etc
  18. D

    Excel macro insert 10 blank rows at top of every tab in a workbook

    Hi, is it possible to use a macro to insert 10 empty rows in row 1 of a workbook and do this for every tab in the workbook? Then I would like to copy a table and I insert this into the 10 blank rows created? I have 100 tabs on the workbook so want to avoid doing things manually. Thanks.
  19. N

    Password Protecting Worksheet from Viewing or Alternatives

    Is it possible to have multiple people share the same workbook with different permissions? Let's say everyone has access to the workbook file, but they have to have a passcode to view a certain tab? OR If you create the spreadsheet tabs to be very hidden, is it possible that the person who...
  20. N

    Formula to identify text in one cell and group in in a new tab?

    BLUF - I looked through the threads best I could and did not see this answer, so I am very sorry if this scenario has already been answered. What I have is a workbook with 6 tabs (one "data" tab and 5 other tabs representing the days of the week). The data tab contains a list of 22 students...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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