worksheeets

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...

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?

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...