worksheeets

  1. C

    Loop Though all worksheets in work book

    HI all i know I'm missing something very small but i'm lost, i have the below code that i need to loop though every worksheet in the workbook, but it only works on the worksheet i'm on what am i missing Please Sub Copy() Dim WB As Workbook Dim ws As Worksheet For Each ws In Worksheets...
  2. V

    Checking if a row is blank on every worksheet

    I have a excel workbook having 70 worksheets. Now, I want to check if Row 13 on every worksheet is blank or not. If not blank, then I want name of that worksheet. Is there any excel formulae to get that detail without checking every worksheet separately?
  3. D

    Copy and paste worksheets

    This code works fine except the worksheets end up a different order in the Destination. Any way of stopping this? Private Sub Jobcard_Templates_Click() TurnOff Dim wkbDest As Workbook Dim wkbSource As Workbook Dim ws As Worksheet Dim wsDest As Worksheet Dim...
  4. P

    VBA Issue copying sheet from one external workbook to another

    Hi This one has been driving me crazy for several hours yesterday and grateful for any help received. Background I have a workbook (ThisWorkbook) that iterates through a folder and collates data from several workbooks (srcWBKs) and copies it to a target output workbook (destWBK). The srcWBKs...
  5. P

    VBA - How to call a new tab with variable name

    Hi, I've written some code in VBA which creates a new tab based on a cell value. As you can imagine this cell value can change. After creating this tab i wanted to paste some information into it. However, I cannot call the tab; i'm getting error 9 subscript out of range. Or Object required...
  6. N

    search and display rows

    Dear all, I have a table with 34 columns and a couple hundred rows. In column no. 5 there in a name that repeats from time to time. In a different sheet i want to make a formula that searches the last row where that name appears in column 5 and display that entire row. Is this possible to make...
  7. P

    Formula with Multiple argumentsacross two worksheets

    Hi All, I am after some assistance with writing a formula. This is the data I have to work with: Sheet1- <tbody> A B C D E F CIS Key Document Created Date Client Name Planner Name Case ID Task when Document was Created 1111111 8/04/2018 Client 1 Planner 1 23565454 2222222...
  8. W

    VBA-Successive vLookup with multiple sheets for data source

    Hello everyone, I would need your help in vba with vLookup. I have one workbook with - One worksheet datasource to not modify - 11 worksheets (number 2 to 12) named from "01" till "11" i.e. outcomes of the questions with relevant range B2:C - a last worksheet named "compilation" The worksheet...
  9. L

    Highlight Cells Containing Search Terms Across All Sheets

    Hi there. I've been working with an excellent piece of code posted (reproduced below) on thespreadsheetguru.com, here: https://www.thespreadsheetguru.com/the-code-vault/2014/4/21/find-all-instances-with-vba This code searches a sheet for text and highlights the cells containing matches. I'm...
  10. K

    Does not Loop like it is supposed to

    I have the following code and I want it to loop through all sheets in the workbook except a sheet called "Summary". Here is the code: Sub DragSort() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets lastrow = Range("A3").End(xlDown).Row Range("H3:I3").AutoFill...
  11. M

    VBA code to create a border around used cells in all worksheets

    Hello excel champions, I'm recording a macro and would like some VBA code help. I'm trying to make a border around all used cells in all worksheets (I have around 50 worksheets open at one time). When I use the macro there will be a variable number of used cells. I would love help designing...
  12. F

    Help with INDEX and MATCH Formulas

    Hi all, I am new to the site, so forgive me if I am unclear. I am struggling to perform a task on excel. I am trying to create a report to match data on 2 different worksheets and then return a specific cell value. I am new to INDEX and MATCH formulas but from my research I am thinking this...
  13. Y

    Using Wordart in Excel

    Why is it that when I use Wordart in a worksheet it just places itself in the middle of the screen? For example: I click on cell D5 which is where I want to put the text but after I click on wordart and write "anything" the text just remains in the middle of the worksheet and have to move it...
  14. M

    Vlookup query

    Hi, I'm a newby to the site so first of all would like to say thanks for letting me join:) My question (which may seem rather basic) is that I have 2 worksheets taken from different workbooks. The first one contains information for interested customers, ie. company name, contact, type of...

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