1. C

    Count Words in cell and ignore blanks

    Hello, I am trying to create a word/phrase counter where it counts the contents of the cell (regardless of how many words are in there), and shows how many times it appears in the range. I apologize if it sounds confusing, but here is the example: Source: Genre Number Historical...
  2. S

    Copy data from all worksheets into one but not below but sideways

    Hello. How to copy data from all worksheets in a workbook, into a new single worksheet, creating a new worksheet named "Combined" but not adding them below into same columns (last used row +1), but to the side. First data from the first copied worksheet into "Combined" shoud go into A1, then...
  3. G

    Exclude one sheet name from "For Each ws In Worksheets"

    Hi there, I have a macro that walks through each worksheet in a workbook and gets data to collate into another workbook. I would like to add another worksheet where I will analyze the data that has been collated. How can I keep the analysis worksheet that I created after the initial macro run...
  4. C

    Merge tables/cells from multiple worksheets

    I have a workbook that contains several worksheet, each with exactly the same layout but differing data. This is an expense report and each worksheet is a different employee's expense report. Each sheet has varying numbers of entries, and is broken into (possibly) two pages. Page 1 and page 2...
  5. C

    Loop through worksheets take last line add to summary tab

    1) Loop through unknown amount of tabs. Take the last row containing data from each worksheet move to the top of each worksheet 2) Look through unknown amount of tabs. Take last row from each tab and input in same order on a summary tab. Unknown number of tabs as I want to build this to support...
  6. G

    VBA Loop through all worksheets in a file , find a specific value and delete all rows above that value

    Hi All, I have a work book with the word " Work Order" in many of the worksheets. I am looking for a VBA code that would loop through all worksheets , find the cell containing the term "work order" and delete all rows above it. Regards
  7. G

    VBA Loop through worksheets and update formula

    Hi All, I have a list of worksheet names in "Sheet1" range B2:B100. I would like to paste the formula : ActiveCell.FormulaR1C1 = "=CONCATENATE(Sheet1!R[1]C[1],""C25"")" into cell A1 of each worksheet mentioned in column B of Sheet1. However, the concatenate formula should keep updating...
  8. M

    Find, Copy and Paste across all worksheets

    Hi, I'm really need help with this. Been trying to achieve this for the last 2 days. On my first worksheet, I have Values in column A and column B there are also values but they are hyperlinks. I'm trying to find the cells with the values from A across the rest of my worksheets and and replace...
  9. A

    VBA/Macro "Return to most recent worksheet"

    I have a macro I want to iron out... I need to copy/paste specific columns from one work sheet to another. I believe I have it to where when I run the macro, it will successfully copy/paste the columns. My problem is the way I wrote the macro, it only knows to do it between two certain...
  10. M

    Altering conditional formatting macro to work across different worksheets

    Hi there, I have a conditional formatting macro that works well comparing lists of non-matching data on the same worksheet. What it does fail to do is to also compare data lists on two different worksheets. Is there a way to adjust the code so that it handles selecting data from 2 different...
  11. N

    Looking to find cell value among specific sheets in workbook

    Hi, Thanks for looking at my question. I am working in Excel 2016. I want to look up a specific cell value from among a range of worksheets (in the same workbook) and have it return the worksheet name the value is found on. The sample page from the workbook is in the link below, i tried to...
  12. S

    Copy worksheets to new workbook, delete connections, then save new workbook

    I am trying to copy two worksheets to a new workbook and rename/save that new workbook. When I copy the worksheets over - the queries are copying with it...which is causing issues when I try to save the new workbook. To get around this, I am having to delete the queries / connections...then...
  13. Dan Wilson

    Controlling print-outs

    Good day. I am running Excel out of Office 365 on Windows 10 Home. I have a workbook that contains seven worksheets. Each of the worksheets has a group of Macros that allow the user to sort the data of each worksheet by different columns. The worksheets contain up to 200 rows with 125...
  14. G

    Hide and Show worksheets

    Hi everyone I have a question in regards to hiding worksheets.. i do know how to do this in the usual manner. although i was wondering is there a way using vba to hide a worksheet, and then show the worksheet if a user clicks on a button, then once the user goes back to the main dashboard the...
  15. S

    Show different worksheets with Camera Tool but the ability to edit data shown?

    Using this YouTube video as a guide I have created a Dashboard of sorts which has a Dropdown box and this shows data from numerous sources. The sources are mainly Pivot Tables but is there a way to actually edit whatever is being shown in the Camera...
  16. C

    SumIf Across Multiple Worksheets

    Hello Everyone, wondering if someone might be able to help me out with a formula I am having trouble with. I have researched the formula extensively on-line and can't seem to get it to work. Basically, I am trying to use a sumifs formula with multiple criteria that sums across multiple...
  17. D

    Average over multiple worksheets

    Looking to get the average of a single cell over multiple worksheets, but I need it to always go to the last worksheet as I will be adding more sheets. =AVERAGE(Sheet1:????!A1) Thanks
  18. tlc53

    VBA Code Amend - Protect All Worksheets, Allow Formatting of Columns & Rows

    Hi, I found this neat VBA code to protect / unprotect all worksheets without having to do each one manually. See below. The only problem is, it only allows; - Select Locked Cells - Select Unlocked Cells Whereas I want another 2 options to be included as well; - Format columns - Format rows Does...
  19. 0

    Change cell value on multiple worksheets using a wildcard

    My workbook contains many sheets and before closing the workbook I would like to replace the same cell on all worksheets with the same text. For example, certain cells replace all that start with "rateid_???". I have tried the following code but receive an error on the IF ws.Range…… row. Could...
  20. E

    Loop through sheets in another workbook

    Hi all, Need some help adding some coding to loop through tabs in another workbook. The code opens up a file(s) in a specific folder and the aim is to just copy all data in all tabs into one tab within DataDump file. Sub Execute_Files()Dim objFSO As Object, objFolder As Object, objFile As...
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